Formatting a Cell for a Specific Number
Posted on 2011-10-15
I need to have the cells to be formatted a specific way - they will be either 13- or 16-digits.
Right now, it seems like the 13 digits are showing up OK, but the 16 digits are being reformatted - mainly the last number is being changed from what I enter to a "0". For example, if I enter 4444444444444444, Excel changes it to 4444444444444440. I have tried General and Special but they don't seem to work.
What format can I use so that Excel will show the specific number?
I am using Excel 2010 Professional Plus.