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

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

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