#1
|
|||
|
|||
Numbers are driving me crazy
I just don't understand why, in some cases where the cell will be formatted as "General", Excel will drop the first number should it be "0", and in other cases where it won't drop the "0" even though the cell is formatted as "General".
Case in point. I entered the number "00029970" and the cell was formatted as "General" and it dropped the first 3 zeros. I entered another number "0001A67C" and no zeros were dropped and the cell was formatted as "General". Does Excel look at the entire entry and because there is a letter after the "1", it treats the entry differently? The only way I have found to keep a leading "0" is to format the cell as "Text". The entries are actually serial numbers, and I have a lot of them, and excel is the best place to keep them because of the ability to find a specific number. |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Fitting text to shape - this is driving me crazy | StratusDancer | PowerPoint | 2 | 10-31-2015 10:44 AM |
Word Driving Me Crazy - page numbering | mrush | Word | 4 | 10-16-2015 10:13 PM |
Audio problem thats driving me crazy | pcbguy | PowerPoint | 10 | 04-26-2012 08:56 AM |
A number of issues driving me crazy | seanterry125 | PowerPoint | 0 | 01-17-2011 04:46 PM |
Outlook Journal is Driving me Crazy | lujreyes | Outlook | 0 | 11-24-2010 05:21 PM |