|
Next: generique pharmacie canada acomplia generique bon..
|
| Author |
Message |
External

Since: Aug 27, 2008 Posts: 1
|
(Msg. 1) Posted: Wed Aug 27, 2008 10:52 am
Post subject: Date formats don't work Archived from groups: microsoft>public>excel>macintosh (more info?)
|
|
|
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 |
|
| Back to top |
|
 |  |
External

Since: Aug 28, 2008 Posts: 18
|
(Msg. 2) Posted: Thu Aug 28, 2008 12:57 pm
Post subject: Re: Date formats don't work [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
|
|
|
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.TakeThisOut@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 |
|
| Back to top |
|
 |  |
| Related Topics: | Need a date formula to divide a date into 3 columns - Hi I have a spreadsheet with a date mm/dd/yyyy. I need to divide that date into three distinct columns - one for year, one for month, and one for day. Is there a formula or formulas that I can use to take the data in the mm/dd/yyyy format and put it i...
Help with custom formats - Where/what is a good source for help on custom formats where I can get explainations on how to create them and what all the symbols mean (such as the "@" symbol etc)?
DATE - Version: 2008 Operating System: Mac OS X 10.5 (Leopard) Processor: Intel I have a sequential array of dates, 365 cells per year. How do I colour 'today' (A1 today, A2 tomorrow, A3 the day after, all automatic)? I quit Excel every night, if that's an..
DATE FORMULA - I am trying to add number of days, INCLUDING HOLIDAYS, to a date to get a second date. However, the date formula in Excle always exclude holidays. Is there any way I can make the calculate to include holidays ??? To make my self clear: I want to forcas...
Help needed with date format - I've always entered date as yy-mm-dd. In fact when I want to enter Aug 28, 2005, I would only need to enter "5-8-28". With the proper formatting on the cells, the date will be displayed as "2005-08-25", or "050825" or whatev... |
|
You can post new topics in this forum You can reply to topics in this forum You can edit your posts in this forum You can delete your posts in this forum You can vote in polls in this forum
|
|
|
|