Help with numbers
 

How do you lead of with a zero on a spreadsheet? For example, 000635.
Excel wants to delete the zeros with just 635 in the cell.
TIA

Help with numbers
 

Hi
You can start by formatting your cells as "Text" or you can start typing
your numbers with an apostrophe e.g '00234.
The apostrophe will not show in the cells
HTH
John
wrote in message
...
How do you lead of with a zero on a spreadsheet? For example, 000635.
Excel wants to delete the zeros with just 635 in the cell.
TIA

Help with numbers
 

On entry, precede the value with a single quote.
--
Gary''s Student - gsnu2007L


" wrote:

How do you lead of with a zero on a spreadsheet? For example, 000635.
Excel wants to delete the zeros with just 635 in the cell.
TIA

Help with numbers
 

Hi,

If you want to display 6 digit always then highlight the range and choose
Format, Cells, Number tab, Custom and enter 000000 in the Type box.

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"John" wrote:

Hi
You can start by formatting your cells as "Text" or you can start typing
your numbers with an apostrophe e.g '00234.
The apostrophe will not show in the cells
HTH
John
wrote in message
...
How do you lead of with a zero on a spreadsheet? For example, 000635.
Excel wants to delete the zeros with just 635 in the cell.
TIA