If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
date format error in cell
I have one cell that for some reason even though the format is set to
general, when i put in say 2007-2011 i get a pop up box that says date format error. the issue is that this is the only cell in the entire column with this issue. this is a file exported out of SAP to Excel with VBA code in the background. then we insert two columns next to a date column. so the new columns are picking up that format. what i don't understand is why when i change the format the top cell still doesn't work. any ideas? |
#2
|
|||
|
|||
date format error in cell
On Mar 23, 11:07*am, pat67 wrote:
I have one cell that for some reason even though the format is set to general, when i put in say 2007-2011 i get a pop up box that says date format error. the issue is that this is the only cell in the entire column with this issue. this is a file exported out of SAP to Excel with VBA code in the background. then we insert two columns next to a date column. so the new columns are picking up that format. what i don't understand is why when i change the format the top cell still doesn't work. any ideas? I have it figured out. for some reason, the data validation for only the top cell in the column i am inserting next to was set to a date. i removed it and now it's fine. |
Thread Tools | |
Display Modes | |
|
|