View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Talon Talon is offline
external usenet poster
 
Posts: 3
Default How do i append a number with "000"

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