Help with numbers

  • Thread starter Thread starter texraid1
  • Start date Start date
T

texraid1

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
 
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
 
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.
 
Back
Top