View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jim Thomlinson Jim Thomlinson is offline
external usenet poster
 
Posts: 5,939
Default How to get the leading zero's added in a document

Well that did not post right... Try this for a custom format.

[99999] 0000-00000;00000

it will pad zeros and it will format bot 5 and 9 digit zips correctly...
--
HTH...

Jim Thomlinson


"Jim Thomlinson" wrote:

c
--
HTH...

Jim Thomlinson


"sam" wrote:

hi
i have a document which is added with leading Zero's in some of the
columns

for eg., in the ZIPCODE column my value is 09281 but in the display i am
getting it

as 9281. But i want it with the original value. Can anyone tell me how to
get the

original values