Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
leading zero
hi community
how can i place leading zero infront of number, i am using excel 2007 n if yes!...where can i do the setting ? thanks community -- oldLearner57 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
leading zero
Either format the cell as text before entering the number,
or precede the number by an apostrophe to turn it to text, e.g. '0012345, or if you want numbers rather than text, format the cell as 0000000 if you want 7 digits including leading zeroes. I'll leave the 2007 experts to tell you where the relevant format commands are if you can't find them. -- David Biddulph "oldLearner57" wrote in message ... hi community how can i place leading zero infront of number, i am using excel 2007 n if yes!...where can i do the setting ? thanks community -- oldLearner57 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
leading zero
thanks david biddulp :)...got it!
thnaks community -- oldLearner57 "David Biddulph" wrote: Either format the cell as text before entering the number, or precede the number by an apostrophe to turn it to text, e.g. '0012345, or if you want numbers rather than text, format the cell as 0000000 if you want 7 digits including leading zeroes. I'll leave the 2007 experts to tell you where the relevant format commands are if you can't find them. -- David Biddulph "oldLearner57" wrote in message ... hi community how can i place leading zero infront of number, i am using excel 2007 n if yes!...where can i do the setting ? thanks community -- oldLearner57 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
leading 0 (zero) | Excel Worksheet Functions | |||
Keep Leading Zero | Excel Discussion (Misc queries) | |||
leading zero | Excel Discussion (Misc queries) | |||
add leading "0" | Excel Worksheet Functions | |||
Add a leading zero | New Users to Excel |