add zeros in front of numbers
 

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

add zeros in front of numbers
 

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


"dlb1228" wrote in message
...
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

add zeros in front of numbers
 

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)


"dlb1228" wrote:

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

add zeros in front of numbers
 

Custom format as 00000.

This only changes the "appearance" of the number.



"dlb1228" wrote:

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