range of numbers

  • Thread starter Thread starter Guest
  • Start date Start date
If you want the cell to show 095 and not to be used in formulas,
Format / Cell / Number / Text and then enter 095.

If you want to format a number to show 3 digits AND be usable in
formulas then Format / Cell / Number / Custom / 000

Bill Manville
MVP - Microsoft Excel, Oxford, England
 
Back
Top