Excel automatically requires date, want text

Closed
marnott Posts 5 Registration date Thursday October 29, 2009 Status Member Last seen October 30, 2009 - Oct 30, 2009 at 12:33 PM
 BansheeFixer - Dec 8, 2009 at 06:10 PM
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

xpcman Posts 19532 Registration date Wednesday October 8, 2008 Status Contributor Last seen June 15, 2019 1,829
Oct 30, 2009 at 12:45 PM
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
marnott Posts 5 Registration date Thursday October 29, 2009 Status Member Last seen October 30, 2009
Oct 30, 2009 at 01:11 PM
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.
0
xpcman Posts 19532 Registration date Wednesday October 8, 2008 Status Contributor Last seen June 15, 2019 1,829
Oct 30, 2009 at 02:41 PM
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
0
marnott Posts 5 Registration date Thursday October 29, 2009 Status Member Last seen October 30, 2009
Oct 30, 2009 at 02:43 PM
Is there some other way to change format other than from the format menus? Can I replace those cells requiring the date?
0

Didn't find the answer you are looking for?

Ask a question
xpcman Posts 19532 Registration date Wednesday October 8, 2008 Status Contributor Last seen June 15, 2019 1,829
Oct 30, 2009 at 02:54 PM
I don't know the Mac version so I can't comment at all.
0
marnott Posts 5 Registration date Thursday October 29, 2009 Status Member Last seen October 30, 2009
Oct 30, 2009 at 04:57 PM
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.
0
marnott Posts 5 Registration date Thursday October 29, 2009 Status Member Last seen October 30, 2009
Oct 30, 2009 at 05:50 PM
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.
0
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.
0