Talon

Do remember that formatting is only a 'mask'. The underlying data will still
be 5086870 so you will need to be sure that's what you use on any LOOKUPs or
similar

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
DTHIS
web: www.nickhodge.co.uk
blog (non-tech): www.nickhodge.co.uk/blog/

"Talon" wrote in message
...
It worked like a charm, thanks!!!!!

"bigwheel" wrote:

Give your cells a custom format of 10 0's

"Talon" wrote:

I have over 5000 numbers in a single column that i need to append with
triple
0 at the beginning of each, an example is below:

5086870

need it to be

0005086870


any ideas on how to add the "000" prefix to every one of the numbers in
a
column??

TIA and cheers! Talon