ace2ace234
New Member
- Joined
- Sep 30, 2014
- Messages
- 12
Hi All,
I need some help and hope you guys can assist.
I have a file in work that I populate with 18 digit numbers everyday but I need to add two leading zeros to these before create final docs for customers.
I have tried formatting the cells,going to custom and adding them that way but it does not work once I go over 15 digits.
I also tried text and concentrate formulas but to no avail.
Is there a way/Formula that I can do this?
Any help would be much appreciated.
I need some help and hope you guys can assist.
I have a file in work that I populate with 18 digit numbers everyday but I need to add two leading zeros to these before create final docs for customers.
I have tried formatting the cells,going to custom and adding them that way but it does not work once I go over 15 digits.
I also tried text and concentrate formulas but to no avail.
Is there a way/Formula that I can do this?
Any help would be much appreciated.