Excel for Mac date formatting
Closed
roxwhit
Zohaib R
- Posts
- 1
- Registration date
- Friday April 7, 2017
- Status
- Member
- Last seen
- April 7, 2017
Zohaib R
- Posts
- 2368
- Registration date
- Sunday September 23, 2012
- Status
- Member
- Last seen
- December 13, 2018
Related:
- Excel for Mac date formatting
- Excel dd/mm/yyyy format - Guide
- How to convert number to words in excel in mac - Guide
- How to check author of excel file mac - Guide
- Excel for MAC - - Opens all files on desktop - How-To - MacOS
- Excel - Using other file formats - How-To - Excel
1 reply
Zohaib R
Apr 8, 2017 at 02:14 AM
- Posts
- 2368
- Registration date
- Sunday September 23, 2012
- Status
- Member
- Last seen
- December 13, 2018
Apr 8, 2017 at 02:14 AM
Hi Roxanne,
Thank you for writing. I can try to help you. Please use this formula and see if this helps:
=TEXT("4/8","mm-dd")
When using this formula you can replace "4/8" with your date and it should work. Also, you can choose any format such as "mm-dd", "dd-mm", etc.
I will be here if you need any further help.
Thank you for writing. I can try to help you. Please use this formula and see if this helps:
=TEXT("4/8","mm-dd")
When using this formula you can replace "4/8" with your date and it should work. Also, you can choose any format such as "mm-dd", "dd-mm", etc.
I will be here if you need any further help.