1

Trying to add some number in an Excel sheet... the number must be with a zero bero but somehow my Excel skills are not very up to date.

The numbers must be (see below) -000058 instead of "58" is there a smart way to solve the .

enter image description here

Thanks in advance.

Best regards from Kvolle

marc_s
  • 732,580
  • 175
  • 1,330
  • 1,459
Casper Kvolsbæk
  • 65
  • 7
  • Possible duplicate of [Add leading zeroes/0's to existing Excel values to certain length](https://stackoverflow.com/questions/3992541/add-leading-zeroes-0s-to-existing-excel-values-to-certain-length) – Olly Dec 03 '18 at 12:08
  • If you're typing in the values manually, you can just add an apostrophe in front of the number like `'000058`, which will then show the value exactly how you want it to look... – Attie Wagner Dec 03 '18 at 12:31