| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Formatting Odd Number Strings
I have imported a text report into Excel. For some reason the date
string on the text file reads as 20/05/0728. Is there a quick way to reformat the string so it reads 7/28/2005 or even 2005/07/28, for that matter. I really don't want to manually edit 300+ lines! Thanks. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Text Function with Different Formatting for Number | Excel Discussion (Misc queries) | |||
| Number formatting when importing from Access to Excel | Excel Discussion (Misc queries) | |||
| number formatting question | Excel Worksheet Functions | |||
| Pivot Table Drill Down Number Formatting | Excel Discussion (Misc queries) | |||
| Conditional Formatting (Date vs Number) | Excel Discussion (Misc queries) | |||
Threaded Mode
