| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
FORMAT DATE
"All other suggested solutions" does not give much detail.
Have you tried DataText to ColumnsNextNextColumn Data FormatDMY and Finish? Gord Dibben MS Excel MVP On Mon, 10 Dec 2007 05:50:00 -0800, Sarah K <Sarah wrote: I am getting my dates showing as what looks like text but without the little green triangle in the top left corner & all other suggested solutions for converting text to date format is not working so it's obviously not recognising it as text even. What else could it be & how do i get it to date format? What I see in cell is: '31.08.2007 When I check the format, it says it's 'General' but when I change to 'Date' format, nothing changes. Please help! S |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Code Date Format Depending on Computer format | Excel Discussion (Misc queries) | |||
| Convert date from text format to date format | Excel Discussion (Misc queries) | |||
| Convert date + time text format to date format | Excel Worksheet Functions | |||
| Can I change a date with no format (20051111) to date format? | New Users to Excel | |||
| Excel 2000 date format cannot be set to Australian date format | Excel Discussion (Misc queries) | |||
Threaded Mode
