Home |
Search |
Today's Posts |
#1
|
|||
|
|||
putting leading zeros in front of number
I would like to display a number with leading zeros in front of it.
|
#2
|
|||
|
|||
Format the cell with a custom format such as
00000000 (this would put enough leading zeroes in front of the number to make it up to 8 digits). Andrea Jones http://www.allaboutoffice.co.uk http://www.stratatraining.co.uk http://www.allaboutclait.com "caroline argyle" wrote: I would like to display a number with leading zeros in front of it. |
#3
|
|||
|
|||
hi,
you could create a custom format for it but numbers with leading zeros are usually not real numbers, that is a number you would want to do something mathmatical to. ever had a reason to devide your zip code by 2? for that reason i usually recomend that you just format it as text and treat it as such. Regards FSt1 "caroline argyle" wrote: I would like to display a number with leading zeros in front of it. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I force leading zeros in an Excel cell? | Excel Discussion (Misc queries) | |||
Leading zeros | Excel Discussion (Misc queries) | |||
How do I display leading zeros so I can export a fixed in Excel? | Excel Discussion (Misc queries) | |||
Adding + in front of a number | Excel Discussion (Misc queries) | |||
single quote 10-digit number that has leading zeroes & then conca. | Excel Worksheet Functions |