Formatting Date

[Question Boy]

I have a column which contains dates

2008-Jan-10

I have tried changing the cell format, but it has no effect. I have tried
using the Text(..,"yyyy-m-d"), but it has not effect. How can I change the
format so it is formatted like yyyy-m-d?

Thank you

QB

 

[Fred Smith]

You have a column which contains text, not dates. You need to change them to
dates in order to format them. The easiest way is with Text-to-Columns

Regards,
Fred.

 

[Dave Peterson]

Select the column
Data|Text to columns
Fixed width (remove any lines that excel guessed)
Choose Date (ymd) on the third step)

Format the way you like.

Excel doesn't see your text "2008-Jan-10" as a date. That's why changing the
number format didn't change the displayed text.

 

[Question Boy]

Worked like a charm!!! That's a new one for the toolbox (never seen or used
that built-in function before).

Thank you!

QB

 

[Nat]

Thank you Dave,

I never knew this was a feature in excel and I have been writing scripts by
hand to process this kind of stuff. Thanks for the great tool.

Nat