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, 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.
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.
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.
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.