| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to convert data in General Format cells to dates
I have a sheet with many cells set to General Format containing "dates" in
the form "20060913". Is it possible to select all these cells and convert the data to show the date in the form mm/dd/yyyy? Would appreciate your help. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Converting data in General Format cell to a number | Excel Discussion (Misc queries) | |||
| Convert data into proper time format | Excel Worksheet Functions | |||
| How do I convert numeric data to string format (without VBA)? | Excel Worksheet Functions | |||
| converting general cells format to text | Excel Discussion (Misc queries) | |||
| To safety merge cells without data destroyed, and smart unmerge! | Excel Discussion (Misc queries) | |||
Threaded Mode
