| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Text Formatting
I have text direct from a US system in a report, the text is a US date eg
01/30/2004. I would like to complete an aging report and need to find an easy way to convert text 01/30/2004 to 30/01/2004 to allow excel to recognise this as a date. I have around 400 lines of data to convert so dont want to have to do this manually. can anyone help?? Thx -- Suzanne Bond |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formulas dealing with text data | Excel Worksheet Functions | |||
| Conditional Formatting based on Text within Text | Excel Discussion (Misc queries) | |||
| Wrap text limits in Excel 2003 cell formatting | Excel Discussion (Misc queries) | |||
| How can I force certain text formatting in a cell? | Excel Discussion (Misc queries) | |||
| Concatenation formula loses text wrap formatting | Excel Discussion (Misc queries) | |||
Threaded Mode
