How do I format a cell in Excel to show a number begining with zero? For example, 052677.
2006-10-12 08:47:53 · 7 answers · asked by jbvo 2 in Computers & Internet ➔ Software
Set up the "CELL' to show leading zeros.
2006-10-12 08:50:37 · answer #1 · answered by Texan 6 · 0⤊ 0⤋
Put a single-quote when entering the number. It will treat the number as text, though. You can also force the cells to Text format (not Number format), this will have the same effect.
If you want all numbers to be the same number of places with zeroes at the beginning if they are short, you can use Custom format with format like "00000" (as many zeroes as you want the number to be long).
2006-10-12 08:54:03 · answer #2 · answered by romulusnr 5 · 0⤊ 0⤋
Format the cell for text
2006-10-12 08:50:49 · answer #3 · answered by Letsee 4 · 0⤊ 0⤋
You can use an apostrophe to convert the cell contents to text. So type
'052677
in the cell and it should retain the zero.
However, if you then want to use the number for functions, that's a bit harder. Although you could try typing
="052677"
It still might not work for functions, but it's worth trying.
2006-10-12 08:50:42 · answer #4 · answered by Anonymous · 0⤊ 0⤋
you could format your cells/ variety utilising custom Numbers format 0000000 and the type on your variety stay as Numbers yet alway displayed in 7 digits with maximum advantageous zeros.
2016-12-26 17:37:58 · answer #5 · answered by mandeville 3 · 0⤊ 0⤋
one way to do it.
highlight the cell
format cell
select "Custom" under 'number' tab
under 'type: ' box, type in required number of zeros and see the sample text box change
2006-10-12 08:59:07 · answer #6 · answered by jasmine 4 · 1⤊ 0⤋
Hi,
Jasmine is right
2006-10-13 04:26:24 · answer #7 · answered by guerrera 5 · 0⤊ 0⤋