RE: Dates in Excel
From: Alex (Alex_at_discussions.microsoft.com)
Date: 10/19/04
- Next message: birdie: "When opening Excel it ask for Microsoft Office 2000 SR-1 Premium ."
- Previous message: Gord Dibben: "Re: sorting question"
- In reply to: Vic Hitchings: "Dates in Excel"
- Next in thread: Paul Corrado: "Re: Dates in Excel"
- Reply: Paul Corrado: "Re: Dates in Excel"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 19 Oct 2004 14:57:02 -0700
For what it is worth...
If you add dates as text by preceeding the entry with a ' , for example,
'19/11/2004 and then apply the following formula
=LEFT(A8,2)&"."&LOWER((ROMAN(MONTH(A8)))&"."&RIGHT(A8,4))
you will get 19.xi.2004 as the output.
Does this help? Possibly I could modify this to accomodate any needs. But
there is no in-built function with Excel.
Regards
Alex
"Vic Hitchings" wrote:
> In natural history, including museum records, it is commonplace to use a date
> with lower case letters for the month, e.g. 19.x.2004 = 19th October 2004 or
> 01.iii.1999 = 1st March 1999. It would help users if this format were added
> as a standard and could be converted.
>
- Next message: birdie: "When opening Excel it ask for Microsoft Office 2000 SR-1 Premium ."
- Previous message: Gord Dibben: "Re: sorting question"
- In reply to: Vic Hitchings: "Dates in Excel"
- Next in thread: Paul Corrado: "Re: Dates in Excel"
- Reply: Paul Corrado: "Re: Dates in Excel"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
