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: 10493
Loc: Canada
Yes. Check the help for the function.
_________________________
Andrew Bates

Top


Moderator:  Christa_Meissner 
Who's Online
0 registered (), 73 Guests and 1 Spider online.
Key: Admin, Global Mod, Mod
Forum Stats
1847 Members
5 Forums
14239 Topics
69735 Posts

Max Online: 359 @ 11/18/19 09:08 PM
May
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