|
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 |
|
|