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
BansheeFixer - Dec 8, 2009 at 06:10 PM
Related:
- Excel automatically requires date, want text
- Excel date format dd.mm.yyyy - Guide
- Transfer data from one excel worksheet to another automatically - Guide
- Pc restarts automatically - Guide
- Download automatically while roaming - Guide
- Excel free download - Download - Spreadsheets
7 responses
xpcman
Posts
19530
Registration date
Wednesday October 8, 2008
Status
Contributor
Last seen
June 15, 2019
1,827
Oct 30, 2009 at 12:45 PM
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
Good Luck
marnott
Posts
5
Registration date
Thursday October 29, 2009
Status
Member
Last seen
October 30, 2009
Oct 30, 2009 at 01:11 PM
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.
It starts just halfway down the column, above, no problem. I'm on a Mac, OSX, if that matters.
xpcman
Posts
19530
Registration date
Wednesday October 8, 2008
Status
Contributor
Last seen
June 15, 2019
1,827
Oct 30, 2009 at 02:41 PM
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
Good Luck
marnott
Posts
5
Registration date
Thursday October 29, 2009
Status
Member
Last seen
October 30, 2009
Oct 30, 2009 at 02:43 PM
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?
Didn't find the answer you are looking for?
Ask a question
xpcman
Posts
19530
Registration date
Wednesday October 8, 2008
Status
Contributor
Last seen
June 15, 2019
1,827
Oct 30, 2009 at 02:54 PM
Oct 30, 2009 at 02:54 PM
I don't know the Mac version so I can't comment at all.
marnott
Posts
5
Registration date
Thursday October 29, 2009
Status
Member
Last seen
October 30, 2009
Oct 30, 2009 at 04:57 PM
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.
marnott
Posts
5
Registration date
Thursday October 29, 2009
Status
Member
Last seen
October 30, 2009
Oct 30, 2009 at 05:50 PM
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.
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.
