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:  Christa_Meissner 
Who's Online
0 registered (), 45 Guests and 0 Spiders online.
Key: Admin, Global Mod, Mod
Forum Stats
1865 Members
5 Forums
14467 Topics
70660 Posts

Max Online: 432 @ 01/20/25 10:17 PM
April
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