HOW DO I ADD A LETTER BEFORE AN EXISTING NUMBER IN A CELL?
Select all of the cells you want formatted, then perform the formatting.
"PAULP" wrote:
THE PROBLEM IS THAT I NEED TO PERFORM THIS ACTION ON 30,000 CELL ENTRIES.
THANX!
"JMay" wrote:
FWIW:
With the value 123 in Cell A1 - You can do a Format, Custom and in the box
type in "A"00000
and you'll get A00123 displayed.
"vezerid" wrote in message
ups.com...
In a cell next to your number (say A1 has the number, so in B1),
="A"&A1 (or whatever letter you want inside the quotes)
If you want to get rid of the formulas, select the column, Edit|Copy
and then Edit|Paste Special... checking Values.
HTH
Kostis Vezerides
|