Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Leading Zero's in Excel
How do I show Leading Zero's in Excel
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Leading Zero's in Excel
Several methods.
Precede the number entry with an apsotrophe '001234 Pre-format the cell as text. Set up a custom format like 0000000 depending upon the number of digits in the number. Gord Dibben MS Excel MVP On Fri, 17 Nov 2006 14:58:02 -0800, nobby wrote: How do I show Leading Zero's in Excel |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Leading Zero's in Excel
Either format the cell as Text before you enter the value or enter it with a
leading apostrophe, for example '0001234. The apostrophe will show in the formula bar but not in the cell. Regards, Alan. "nobby" wrote in message ... How do I show Leading Zero's in Excel |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Leading Zero's in Excel
you can use formatting
for example if you want 2 to appear as 0001 then format the cell as custom 0000 -- Gary's Student "nobby" wrote: How do I show Leading Zero's in Excel |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Leading Zero's in Excel
And I thought formatting only changed the appearance, not the value
<bg I think you meant that 2 would appear as 0002 when formatted that way. Pete Gary''s Student wrote: you can use formatting for example if you want 2 to appear as 0001 then format the cell as custom 0000 -- Gary's Student "nobby" wrote: How do I show Leading Zero's in Excel |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Leading Zero's in Excel
Thanks for the correction
(I can't even blame the spell-checker this time.) -- Gary's Student "Pete_UK" wrote: And I thought formatting only changed the appearance, not the value <bg I think you meant that 2 would appear as 0002 when formatted that way. Pete Gary''s Student wrote: you can use formatting for example if you want 2 to appear as 0001 then format the cell as custom 0000 -- Gary's Student "nobby" wrote: How do I show Leading Zero's in Excel |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Leading Zero's in Excel
OK, this one is little more tricky. I am exporting numbers that are four
digits long, but may have only one two or three actual numbers? The digits that preceed the actual numbers must be zero (eg- 0001, 0011, 0111). The program that I export them from has the leading zeros in the fields, but they don't show up on the spreadsheet and omit any zero that preceeds an actual number. Depending on how many intagers that are in the number, the number of leading zeros will be different. "Gary''s Student" wrote: Thanks for the correction (I can't even blame the spell-checker this time.) -- Gary's Student "Pete_UK" wrote: And I thought formatting only changed the appearance, not the value <bg I think you meant that 2 would appear as 0002 when formatted that way. Pete Gary''s Student wrote: you can use formatting for example if you want 2 to appear as 0001 then format the cell as custom 0000 -- Gary's Student "nobby" wrote: How do I show Leading Zero's in Excel |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
Leading Zero's in Excel
Just try it. You may like it.
Format to Custom 0000 1 will show as 0001 11 will show as 0011 111 will show as 0111 1111 will show as 1111 Gord Dibben MS Excel MVP On Fri, 28 Dec 2007 14:49:00 -0800, Krl wrote: OK, this one is little more tricky. I am exporting numbers that are four digits long, but may have only one two or three actual numbers? The digits that preceed the actual numbers must be zero (eg- 0001, 0011, 0111). The program that I export them from has the leading zeros in the fields, but they don't show up on the spreadsheet and omit any zero that preceeds an actual number. Depending on how many intagers that are in the number, the number of leading zeros will be different. "Gary''s Student" wrote: Thanks for the correction (I can't even blame the spell-checker this time.) -- Gary's Student "Pete_UK" wrote: And I thought formatting only changed the appearance, not the value <bg I think you meant that 2 would appear as 0002 when formatted that way. Pete Gary''s Student wrote: you can use formatting for example if you want 2 to appear as 0001 then format the cell as custom 0000 -- Gary's Student "nobby" wrote: How do I show Leading Zero's in Excel |
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
Leading Zero's in Excel
"nobby" wrote: How do I show Leading Zero's in Excel Hi, here is my particular problem: I want to enter isbn's into my excel sheets. Some start with 0 and some start with 1. If I select the column as 'text' before entering any numbers, I have no problem. But if I copy and paste a number from the order site, all of the isbns that start with zero lose the leading zero upin the paste. Any ideas? |
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
Leading Zero's in Excel
Format the cell as Text.
And paste directly into the formulabar debbie wrote: "nobby" wrote: How do I show Leading Zero's in Excel Hi, here is my particular problem: I want to enter isbn's into my excel sheets. Some start with 0 and some start with 1. If I select the column as 'text' before entering any numbers, I have no problem. But if I copy and paste a number from the order site, all of the isbns that start with zero lose the leading zero upin the paste. Any ideas? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
I want to keep leading zeros in my excel spreat sheet, How? | Excel Discussion (Misc queries) | |||
Running Excel 2000 VBA Application on Excel 2003 | Excel Worksheet Functions | |||
retain leading zeros when importing | Excel Discussion (Misc queries) | |||
How to prevent Excel from deleting leading zeros? | Excel Discussion (Misc queries) |