Geekpedia Programming Tutorials






Date Formats Don't Work

On Wednesday, August 27th 2008 at 12:52 PM
By King
Greetings.

I have Excel 2008 for Mac with all the updates. For some reason, date
formats no longer work, even in a new spreadsheet. For example, no
matter what the date format is, if I enter "8/8/8", that's just the
way it appears. All other formats seem to work okay, and date formats
USED to work okay. I have been though all the preferences, and I don't
know what I did to mess up the dates.

Thanks in advance!

KO'D

Re: Date formats don't work

by macropod on Wednesday, August 27th 2008 at 10:57 PM
Hi King O,

Do you use an Excel template? Have you, perhaps, formatted the cell(s) in the template as text? If so, change their format to date.

--
Cheers
macropod
[MVP - Microsoft Word]


"King O'Diamonds" <98qf-swmyx@dea.spamcon.org> wrote in message news:bc1bb4lujscd21v2ofk09ecor8sao2k7j8@4ax.com...
> Greetings.
>
> I have Excel 2008 for Mac with all the updates. For some reason, date
> formats no longer work, even in a new spreadsheet. For example, no
> matter what the date format is, if I enter "8/8/8", that's just the
> way it appears. All other formats seem to work okay, and date formats
> USED to work okay. I have been though all the preferences, and I don't
> know what I did to mess up the dates.
>
> Thanks in advance!
>
> KO'D
Latest Tech Bargains

Advertisement

Free Magazine Subscriptions

Today's Pictures

Today's Video

Other Resources

Latest Download

Latest Icons