Formatting Dates

Posted by: Jim_CA_CFE

Formatting Dates - 09/22/11 12:29 PM

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
Posted by: Retired_Guy

Re: Formatting Dates - 09/22/11 01:07 PM

Yes. Check the help for the function.