R
Rio rulz
How do I make Excel leave the zero's at the beginning of the number?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
B
BenjieLop
Rio said:How do I make Excel leave the zero's at the beginning of the number?
Format the cell as TEXT or enter a leading apostrophe ( ' ) befor
keying in the numbers
M
mroby
You must either have the cell(s) formatted as text, which will hold the
actual characters in the cell. Otherwise, you can custom format the cell to
'000' which will display the leading zeros, but not hold them in the cell.
Hope this helps.
actual characters in the cell. Otherwise, you can custom format the cell to
'000' which will display the leading zeros, but not hold them in the cell.
Hope this helps.
A
Anthony
try inserting ' before the 007.
D
Dingo
Change the format of the cell
=> Format Cells
=> Custom
typ in 000
and it works and it is still a number!!
=> Format Cells
=> Custom
typ in 000
and it works and it is still a number!!