Active Topics
Active Posts
Unanswered Posts
Search
Advanced
You are not logged in. [
Log In
]
Adagio Home Page
»
Forums
»
General Discussion
»
Technical Support
» Formatting Dates
Register User
Forum List
Calendar
Active Topics
Search
FAQ
Topic Options
#29001
-
09/22/11
12:29 PM
Formatting Dates
Jim_CA_CFE
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
Adagio Master
Registered: 03/16/99
Posts: 10504
Loc: Canada
Yes. Check the help for the function.
_________________________
Andrew Bates
Top
Previous Topic
Index
Next Topic
Preview
Hop to:
General Discussion ------
General Inquiries Forum
Technical Support
Moderator:
Christa_Meissner
Print Topic
Switch to Threaded Mode
View profile
Send a PM
Add to your Watched Users
View posts
View profile
Send a PM
Add to your Watched Users
View posts
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
Privacy statement
·
Board Rules
·
Mark all read
Default Style
Forum-Style
Forum-Style-New
Softrak_Blue
Contact Us
·
Adagio Home Page
·
Top