add zeros in front of numbers

D

dlb1228

i have an acct# field and want to add 000 in front

585
00125
00356
12

i want to add 00 to 585 and 000 to 12 to make all the same length is
there some place to set this
 
P

Peo Sjoblom

Custom format

00000

If you need to export is as text with leading zeros use a help column and a
formula

=TEXT(A1,"00000")

copy down, select the range and copy and paste special as values in place

Regards,


Peo Sjoblom
 
J

John

try the custom format of 00000 in the cells
--
John
MOS Master Instructor Office 2000, 2002 & 2003
Please reply & rate any replies you get

Ice Hockey rules (especially the Wightlink Raiders)
 
Top