| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date Format Not Responding to MM/DD/YY
Hello, MS Online Community.
I have a column of dates in a spreadsheet where the date is in the following format: "M/D/YYYY" If I look at Format-Cell, I see the Date category highlighted with the MM/DD/YY format type selected, however, the dates in the column will not respond to this format. I did notice that if I double-clicked inside the cell (for the Edit mode) and then clicked elsewhere on the spreadsheet, it would convert to the MM/DD/YY format. There must be a way in which to switch to the Edit mode for an entire column instead of double-clicking individually. Any ideas? Thanks! ssignore |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Date Format Not Responding to MM/DD/YY
Try this -
Select the column Choose Data-Text to column Click FINISH "ssignore" wrote: Hello, MS Online Community. I have a column of dates in a spreadsheet where the date is in the following format: "M/D/YYYY" If I look at Format-Cell, I see the Date category highlighted with the MM/DD/YY format type selected, however, the dates in the column will not respond to this format. I did notice that if I double-clicked inside the cell (for the Edit mode) and then clicked elsewhere on the spreadsheet, it would convert to the MM/DD/YY format. There must be a way in which to switch to the Edit mode for an entire column instead of double-clicking individually. Any ideas? Thanks! ssignore |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Date Format Not Responding to MM/DD/YY
That worked! (As long as 'Fixed Width' is selected instead of 'Delimited')
Much appreciated. Regards, Simone "Sheeloo" wrote: Try this - Select the column Choose Data-Text to column Click FINISH "ssignore" wrote: Hello, MS Online Community. I have a column of dates in a spreadsheet where the date is in the following format: "M/D/YYYY" If I look at Format-Cell, I see the Date category highlighted with the MM/DD/YY format type selected, however, the dates in the column will not respond to this format. I did notice that if I double-clicked inside the cell (for the Edit mode) and then clicked elsewhere on the spreadsheet, it would convert to the MM/DD/YY format. There must be a way in which to switch to the Edit mode for an entire column instead of double-clicking individually. Any ideas? Thanks! ssignore |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Date Format Not Responding to MM/DD/YY
I thought you would figure that out... :-)
"ssignore" wrote: That worked! (As long as 'Fixed Width' is selected instead of 'Delimited') Much appreciated. Regards, Simone "Sheeloo" wrote: Try this - Select the column Choose Data-Text to column Click FINISH "ssignore" wrote: Hello, MS Online Community. I have a column of dates in a spreadsheet where the date is in the following format: "M/D/YYYY" If I look at Format-Cell, I see the Date category highlighted with the MM/DD/YY format type selected, however, the dates in the column will not respond to this format. I did notice that if I double-clicked inside the cell (for the Edit mode) and then clicked elsewhere on the spreadsheet, it would convert to the MM/DD/YY format. There must be a way in which to switch to the Edit mode for an entire column instead of double-clicking individually. Any ideas? Thanks! ssignore |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| convert serial date format to normal date format | Excel Discussion (Misc queries) | |||
| Convert date + time text format to date format | Excel Worksheet Functions | |||
| Can't bold or format because program goes into "not responding" | Excel Discussion (Misc queries) | |||
| Can I change a date with no format (20051111) to date format? | New Users to Excel | |||
| Excel 2000 date format cannot be set to Australian date format | Excel Discussion (Misc queries) | |||
Linear Mode
