| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel,microsoft.public.excel.misc
|
|||
|
|||
Changing to date format
I have a sheet that has many rows with a date that looks like a text format.
If I right click on the cell I can check it to a number and then to an mm/dd/yyyy. My question is can I change all the rows to this format is one shot. I tried to choose the whole column and do a change format but that didn't work. How would I go about changing mmddyyyy to mm/dd/yyyy? Thanks, |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Changing date format in a footer | Excel Discussion (Misc queries) | |||
| format date in excel | Excel Discussion (Misc queries) | |||
| Why Does Date Format Change on Chart | Excel Discussion (Misc queries) | |||
| Imported Date & Time format with calcs. managed in excel from imrp | Excel Worksheet Functions | |||
| Format Cells - Date options | Excel Discussion (Misc queries) | |||
Threaded Mode
