View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Toppers Toppers is offline
external usenet poster
 
Posts: 4,339
Default 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