Hottest Free Downloads - DownloadPipe.com Over 197,000 downloads! Bookmark Now!
DownloadPipe.com - New Downloads Every Minute
 SEARCH:
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

Date formats don't work

 
   Mac (Home) -> Mac Excel RSS
Next:  generique pharmacie canada acomplia generique bon..  
Author Message
King O'Diamonds

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
Login to vote
macropod

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
Login to vote
Display posts from previous:   
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...
       Mac (Home) -> Mac Excel All times are: Pacific Time (US & Canada) (change)
Page 1 of 1

 
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
Categories:
 Windows Forums
 Game Forums
 Linux Forums
  Mac Forums
 PDA Forums
 Mobile Forums
  Top  |  Store  |  RSS Feeds RSS  |  Data Feeds  |  Advertise  |  Submit  |  Bookmark  |  Newsletter  |  Contact