Forum Discussion
A problem retaining leading zeros in Excel 2010
I have a simple spread sheet containing customer numbers which variously range from 4 to 968 (ie up to 3 digits), and in Excel, normally, no leading zeroes are retained. By changing the colum...
Hi Ross,
Supposing that the customer number is in cell A1, please use this formula:
=TEXT(A1,"000")&"/1000"
Regards