FORMAT DATE

S

Sarah K

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
 
M

Mike H

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
 
G

Gord Dibben

"All other suggested solutions" does not give much detail.

Have you tried Data>Text to Columns>Next>Next>Column Data Format>DMY and Finish?


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Convert Text Entry to Date Format 1
Date format 5
Resetting cell format from TEXT to NUMERIC and DATE 2
Convert Date string to date format 7
date format 1
Changing dates to date format 5
paste web without date format 1
Pivot Table date format 1

Top