| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
FORMAT DATE
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
FORMAT DATE
Sarah,
Text to columns should work:- Select your (non) dates then Data|Text to columns Select fixed width Next Next Select date and DMY from the dropdown Finish Mike "Sarah K" 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 |
|
#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 |
| Reply |
| 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) | |||
Linear Mode
