Date Formatting Error in Excel 00

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

meganjl - 20 Dec 2007 16:48 GMT

Hello,

My question is regarding formatting dates in Excel 2000. I often download a
spreadsheet with a date column in the format 12/20/2007. This column
downloads in General format and I can format it as Date. However, I cannot
change how the date is displayed to 20-Dec-07. Is there anything that can be
done to fix this?

Thank you,

Reply to this Message

Gary''s Student - 22 Dec 2007 12:37 GMT

First make sure the value is a true date. Reformat the cell to General and
you should see:

39436

Next:

Format > Cells... > Number > Custom > dd-mmm-yyyy

Signature

Gary''s Student - gsnu200761

> Hello,
>
[quoted text clipped - 5 lines]
>
> Thank you,

Reply to this Message