Excel automatically requires date, want text

Closed
Report
Posts
5
Registration date
Thursday October 29, 2009
Status
Member
Last seen
October 30, 2009
-
 BansheeFixer -
Hello,
Halfway down an Excel column the cells start requiring all text in format of a date. Above, I can type text, below it requires 10/30/2009-type entries. I don't know what I changed but I need to type text. How do I do this?
thanks,
Mark

7 replies

Posts
19532
Registration date
Wednesday October 8, 2008
Status
Contributor
Last seen
June 15, 2019
1,941
You have changed the column FORMAT to date. You can right click the column header and select format and change it to text.

Good Luck
1
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2821 users have said thank you to us this month

Posts
5
Registration date
Thursday October 29, 2009
Status
Member
Last seen
October 30, 2009

Thanks, and drat. That's just what I had thought, and tried changing it from the format menu on the side, from the drop down on the top, and now with the right click access and every time it reads "general" but behaves "date." I can't figure it out.

It starts just halfway down the column, above, no problem. I'm on a Mac, OSX, if that matters.
Posts
19532
Registration date
Wednesday October 8, 2008
Status
Contributor
Last seen
June 15, 2019
1,941
That is a strange problem. Probably a file glitch of some kind. you might try to export the file and then importing it to a new spreadsheet. If you export it as a comma delimited file it will probably loose all its formatting and upon importing you can then reapply the formatting you want.

Good Luck
Posts
5
Registration date
Thursday October 29, 2009
Status
Member
Last seen
October 30, 2009

Is there some other way to change format other than from the format menus? Can I replace those cells requiring the date?
Posts
19532
Registration date
Wednesday October 8, 2008
Status
Contributor
Last seen
June 15, 2019
1,941
I don't know the Mac version so I can't comment at all.
Posts
5
Registration date
Thursday October 29, 2009
Status
Member
Last seen
October 30, 2009

Thanks, xpcman, I tried that, to no avail. Maybe I can copy it all, paste it in another format, then try again to get what I want. Most peculiar. I don't think Mac or PC matters much, different key commands, but the programs run the same so far as I can tell. There's increasingly little difference, Mac to PC, nowadays, except that Justin Long is definitely getting the better movie career than the PC/Daily Show guy.
Posts
5
Registration date
Thursday October 29, 2009
Status
Member
Last seen
October 30, 2009

Any help from anyone would be much appreciated. Don't worry if you are more versed in Mac or PC, if you know where the problem might be, or have an idea how to reformat the whole thing to rid it of this glitch, no matter what system you use, please let me know. I'm flummoxed.
Don't know if your still having the same problem, but just ran into this as well. Was entering numbers in the cells, when all of a sudden, it takes this number; 10-9020 and changes it to a oct-20 date! Whats really strange is that I went to my other files and tried it and it does the same thing! If I type in any number 1-12 followed by a dash, it puts it as a date. So I then tried this on my other computer with different files, SAME THING!! What the hell is going on? Running Vista (yeah, yeah, I know) on one and the other has XP. Any help would be greatly appreciated.