HOW DO I ADD A LETTER BEFORE AN EXISTING NUMBER IN A CELL?
THANK YOU! WORKS PERFECTLY!
"vezerid" wrote:
If the cell displays the formula there are two things to check:
1. The number format of the cell w/ the formula. Format|Cells...|Number
tab. If it is Text, then this explains why you are seeing the formula.
If so, select the entire column (by clicking the column header) and set
the format to General.
2. Tools|Options|View and see if the Formulas checkbox is checked. If
so, uncheck.
This is what you should do if you want to do it with formulas. Beware,
the suggested formula can be copied as far down as necessary. If you
have it in an adjacent column then, select B1 and bring the mouse
pointer over the bottom-right corner of the selection border, where you
see the Autofill handle. By double-clicking it will be automatically
copied as far down as necessary.
The difference between the formula and the formatting technique:
The formula will generate a *new value* and it needs an additional
column first. If you format it as suggested, the value is not changed
and it simply *displays* the character at the beginning. I.e. you can
still use a formula like =2*A1 and it will give you twice the number
part.
You choose what is best for you.
HTH
Kostis Vezerides
|