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 |