I have a spreadsheet made in excel 2007. In one of the cells is a number with three zeros in front of it and one zero at the end. However it always drops the zeros and shows only the other numbers. I select the cell and click on "format cells", but there is nothing I see that will show all the zeros. It seems a little dumb--but maybe it's just me. isn't there a way to show everything?
I simply want 00030260 displayed as 00030260. It's important that it displays it exactly that way.
Yes, it is a product number. Putting the quote mark in front of it took care of it. Thank you
Putting a " ' " in front, technically converts a number to text. Excel has an option to treat text as numbers when you are doing calculation. Don't know if all your numbers are 8 digits long or if you would mind converting them all to 8 digits but what I do when I want to show a leading 0(s) or what ever is to format the range to a custom format such as this: (choose custom and type in the amount of zero's you want in your format) Then you can type in 30260 and it will automatically show the leading 3 zeros
Quote