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