Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to get the leading zero's added in a document
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to get the leading zero's added in a document
"sam" wrote in message
... 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 Sam, Most people don't use zip codes in calculations, so in Excel they might as well be text that just look like numbers. So... Format/Cells/Text or Format/Cells/Custom/00000 HTHelps Beege |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to get the leading zero's added in a document
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
retain leading zeros when importing | Excel Discussion (Misc queries) | |||
Spliting a number with leading zeros | Excel Discussion (Misc queries) | |||
Leading zeros | Excel Discussion (Misc queries) | |||
Displaying leading zeros in an Excel spreadsheet | Excel Discussion (Misc queries) | |||
Leading Zeros in Numeric Values | Excel Worksheet Functions |