adding a prefix to cells

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

Hi Paul,

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

HTH
Regards from Brazil
Marcelo

"PaulPA" escreveu:

>
> I wish to add "B03-" to each cell in a column of numbers. I'm sure it's
> really simple to do, but I can't seem to find out how. The column has
> about 1,500 four digit numbers, so I don't want to do it manually.
> Please could someone help me!
>
>
> --
> PaulPA
> ------------------------------------------------------------------------
> PaulPA's Profile: http://www.excelforum.com/member.php...o&userid=36454
> View this thread: http://www.excelforum.com/showthread...hreadid=562171
>
>

Thanks Marcelo

Paul