Number in excel

  • Thread starter Thread starter Guest
  • Start date Start date
Hi

If you need to keep the cell as a number - so you can do calculations on
it - you could use a custom format like 000000.
If you don't need it to retain its maths ability, use an apostrophe '
first (ie '012678)
 
Back
Top