| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
I need to convert a date value into three columns
I work with a lot of sports related data:
Wins - Losses - Ties is reprented as 10-15-1 When I copy and paste this information into excel, it converts it to a date value I need to get this information back into a text format and break it into three columns. A=10 B=15 C=1 How can I do this automatically, without having to manually enter it. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to convert Gregorian date into Hijri Date in Excel 2007? | Excel Discussion (Misc queries) | |||
| How do i convert a date into 3 seperate columns? | Excel Discussion (Misc queries) | |||
| to convert columns to rows having mulit independent group columns | Excel Worksheet Functions | |||
| Convert a julian gregorian date code into a regular date | Excel Worksheet Functions | |||
| How do I convert numbered columns to lettered columns? | Excel Discussion (Misc queries) | |||
Threaded Mode
