Topic Options
#29001 - 09/22/11 12:29 PM Formatting Dates
Jim_CA_CFE Offline
Adagio Enthusiast

Registered: 09/22/10
Posts: 21
Loc: Winnipeg, Canada
Hello,

When I insert the following formula:

=GLFPE(M$10)

The format I get is "dd-mm-yy". Is there any way to format this so it reads "May 31, 2011" (for example)?

Thanks,
Jim

Top
#29007 - 09/22/11 01:07 PM Re: Formatting Dates [Re: Jim_CA_CFE]
Retired_Guy Offline
Adagio Master

Registered: 03/16/99
Posts: 10504
Loc: Canada
Yes. Check the help for the function.
_________________________
Andrew Bates

Top


Moderator:  Softrak Support 
Who's Online
1 registered (Patricia B.), 135 Guests and 4 Spiders online.
Key: Admin, Global Mod, Mod
Forum Stats
1867 Members
5 Forums
14569 Topics
71100 Posts

Max Online: 1148 @ 11/22/25 01:55 AM
December
Su M Tu W Th F Sa
1 2 3 4 5 6
7 8 9 10 11 12 13
14 15 16 17 18 19 20
21 22 23 24 25 26 27
28 29 30 31