Welcome to Soft32 Forums!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

Dates show as long numbers

  
   Soft32 Home -> Mac -> Excel RSS
Next:  Office software available  
Author Message
ardisius

External


Since: Jan 15, 2009
Posts: 4



(Msg. 1) Posted: Tue May 12, 2009 9:01 am
Post subject: Dates show as long numbers
Archived from groups: microsoft>public>mac>office>excel (more info?)
Version: 2004
Operating System: Mac OS X 10.4 (Tiger)
Processor: Power PC

Opening a .xls file from a PC shows dates correctly, but when I save it as a new [Mac] file dates show as long numbers even though show correctly in the input box. e.g., "7/15/2008 4:23:13 PM" displays as "39644.6827893518"

I think it has something to do with 1904 dating but I have 1904 Date System unchecked.

Any clues, please?

Regards

Roy
Back to top
Login to vote
ardisius

External


Since: Jan 15, 2009
Posts: 4



(Msg. 2) Posted: Tue May 12, 2009 9:59 am
Post subject: Re: Dates show as long numbers [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
Thanks bob, but yes, the columns are formatted as dates [the original file from the PC source had the dates okay]

Roy
Back to top
Login to vote
Bob Greenblatt

External


Since: Jun 08, 2005
Posts: 810



(Msg. 3) Posted: Tue May 12, 2009 12:16 pm
Post subject: Re: Dates show as long numbers [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
On 5/12/09 12:01 PM, in article 59b74501.-1.DeleteThis@webcrossing.caR9absDaxw,
"ardisius@officeformac.com" <ardisius.DeleteThis@officeformac.com> wrote:

> Version: 2004
> Operating System: Mac OS X 10.4 (Tiger)
> Processor: Power PC
>
> Opening a .xls file from a PC shows dates correctly, but when I save it as a
> new [Mac] file dates show as long numbers even though show correctly in the
> input box. e.g., "7/15/2008 4:23:13 PM" displays as "39644.6827893518"
>
> I think it has something to do with 1904 dating but I have 1904 Date System
> unchecked.
>
> Any clues, please?
>
> Regards
>
> Roy
No, it does not have anything to do with the 1904 date option. It has to do
with the format of the cell. Make sure the cell is properly formatted as a
date and is not text.

--
Bob Greenblatt [MVP], Macintosh
bobgreenblattATmsnDOTcom
Back to top
Login to vote
Display posts from previous:   
Related Topics:
Stop turning numbers into dates! - I'm entering numeric values such as 1/5, 9/27 and 10/28, into an Excel spreadsheet. Excels keeps trying to "help&...

ordinal numbers in dates in Excel - I'm sure there is an easy way which I have forgotten but I want to be able to print dates like 22nd Feb 2003. Using d...

Can you automatically change positive numbers to negative .. - My brother is working on a worksheet and he needs to change all the positive numbers to negative numbers and all the..

long time to quit - What would make Excel take an unusually long time to quit? This has begun after I reinstalled the OS and after replace...

How to split long database - I have a large excel file (~30000 row) i i want to split it to 1000 rows each into separated files. We use to do it..

need help with dates - Dates ?? If date in column b1=mar-07, (which by the way looks like 03-07-2007 on the command line, even if i format i...
       Soft32 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
 Linux
  Mac
 PDA

[ Contact us | Terms of Service/Privacy Policy ]