|Subject:||Re: Pre-pending and post=pending cell data in Excel|
|Posted by:||Dave Peterson (ec357…@msn.com)|
|Date:||Tue, 07 Oct 2003|
Do you have to have the asterisks in the cell or can it just look like they're
If your data is really numbers, you could use a custom fromat of:
The asterisks aren't really in the cell, they just look like it. On the other
hand, the value is still a number, so you can do arithmetic with it.
David Neustadt wrote:
> Is there a VB command or a way in Excel to prepend and postpend data
> in an Excel cell.
> For example, let's say I have a column with the following numbers
> How can I format all the cells in that column so that numbers have an
> * at the beginning and at the end? So my results would look like this.
Pre-pending and post=pending cell data in Excel posted by David Neustadt on 7 Oct 2003