adding a prefix to cells

P

PaulPA

I wish to add "B03-" to each cell in a column of numbers. I'm sure it'
really simple to do, but I can't seem to find out how. The column ha
about 1,500 four digit numbers, so I don't want to do it manually.
Please could someone help me
 
M

Marcelo

Hi Paul,

format as custom "B03" - #.##0

HTH
Regards from Brazil
Marcelo

"PaulPA" escreveu:
 
Top