I'm having trouble with the default formatting settings. In places throughout my model, I have entered integers to use to count for vlookups / index matches etc. But now, excel has decided to autoformat all of those integers under general formatting to date formatting, so any number looks like "Jan -00"
Is there a way to change this back so that it looks like 1, 2, 3, 4...again?
I read through a lot of the discussions already, but if there is a particularly helpful one, could someone please direct me to it? thanks!!
Hi, sorry, I don't have an answer for you. Did you ever get a solution for this? I have the same issue. Thanks
hi-light the cells, right-click, select format...format to either general, or to number with your choice of decimal places
You need to modify the Normal style to reset the number format to General rather than Date. There does not seem to be any pinpointed cause for this corruption yet that I have seen, although many reports of it seem to involve a lot of pivot tables in the workbook.
Good luck.
Have attempted several times to convert to General. Even used the CUSTOM setting. This file originated from a WORD file, so a copy and paste into EXCEL. I can change the formatting to general, however, when I enter a number reference of 01/10.... the cell reverts to date and I get Jan 10. I have tried deleting the column and re-entering the data from scratch, set it as GENERAL to start and again, once I enter any number that starts between 1 and 12, I get Jan - Dec.... Have used several versions of Excel...2003, 2007 2010.....
If you enter something that looks like a date, Excel will try and 'assist' you by formatting the cell as date unless you either pre-format the cell as Text or prefix the data with an apostrophe.
Good luck.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks