| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
leading 0 (zero)
How do I get a leading 0 (zero) in Excell (2003)?
|
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
leading 0 (zero)
Several ways to go about it but I use text, note this will change the numbers
to text, replace "000" with total number of digits =Text(A1,"000") -- -John Northwest11 Please rate when your question is answered to help us and others know what is helpful. "MrA" wrote: How do I get a leading 0 (zero) in Excell (2003)? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
leading 0 (zero)
format the cell as text, you can still perform math functions on the number
"MrA" wrote: How do I get a leading 0 (zero) in Excell (2003)? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
leading 0 (zero)
=0&A1, or look at the other replies.
-- David Biddulph "MrA" wrote in message ... How do I get a leading 0 (zero) in Excell (2003)? |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
leading 0 (zero)
If you want a leading zero, so that all numbers have
a fixed size use Custom Format 00000 or however many digits you want Steve On Thu, 01 Feb 2007 12:30:01 -0000, MrA wrote: How do I get a leading 0 (zero) in Excell (2003)? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Display leading zeros in numeric value without converting to text | Excel Discussion (Misc queries) | |||
| Looking to add a leading 0 @ start of numbers | Excel Discussion (Misc queries) | |||
| Keeping leading 0's | Excel Discussion (Misc queries) | |||
| Leading Zeros | Excel Discussion (Misc queries) | |||
| Remove leading space | Excel Worksheet Functions | |||
Hybrid Mode
