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.
|
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. |
Bat export to filename date text file Data validation box excel 2007, make dates entered in only as 4 dijits Every time you enter a value into a cell in the worksheet, excel automatically Every time you enter a value into a cell in the worksheet, excel automatically ____ formulas. Excel cell format date hh:mm:ss format Excel color cell data vba Excel conditional format insert text Excel date text to date in dd mm yyyy format Excel formula to separate text to columns by "last space" only Excel function vba "find text in range" Excel if then date Excel macro if data range Excel vlookup to find text Export to filename date text file Functions on excel to read data from cell How make excel automatically select colour based on the text selected from the drop down box Index match in excel to compare data Vba excel macro copy data to new excel file