| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to convert 19900301 to 03/01/1990
Here's an easy way:
Select your data then go to Data/Text to Columns, select "Fixed Width" hit NEXT NEXTX then select "Date" in the upper right corner and in the drop down menu select YMD and hit "Finish". HTH JG "clarice" wrote: how can a date that is set up in excel as 19900301 be converted automatically to read 03/01/1990? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Convert decimal degree (lattitude/longitude) into Degree, | Excel Discussion (Misc queries) | |||
| How to create formula to convert? | Excel Worksheet Functions | |||
| CONVERT Function Disappered in Excel | Excel Discussion (Misc queries) | |||
| convert decimal number to time : convert 1,59 (minutes, dec) to m | Excel Discussion (Misc queries) | |||
| Convert Numeric into Text | Excel Worksheet Functions | |||
Hybrid Mode
