Excel for Mac date formatting [Closed]

Question

Excel for Mac date formatting [Closed]

Report

roxwhit

Posts: 1
Registration date: Friday April 7, 2017
Status: Member
Last seen: April 7, 2017

- Apr 7, 2017 at 04:12 PM
Zohaib R

Posts: 2368
Registration date: Sunday September 23, 2012
Status: Moderator
Last seen: December 13, 2018

- Apr 8, 2017 at 02:14 AM

Hello,

I have two columns one for the month/day and one for the year. When I formatted the month/day column it automatically adds the year in which I entered the data. We add data each year but I do not want a year in the column so it will sort properly. I have tried many things to get it to format properly, even using the Data, text to column and nothing seems to work.

Thanks, Roxanne

Excel for Mac date formatting
Excel dd/mm/yyyy format - How-To - Excel
Excel date to general format - How-To - Excel
Excel for MAC - - Opens all files on desktop - How-To - MacOS
Excel - Using other file formats - How-To - Excel
How to change author name in excel 2016 mac - How-To - Excel

1 reply

Ask a question

Zohaib R · Answer 1 · 2017-04-08T02:14:52-0400

Answer 1 / 1

Zohaib R

Posts: 2368
Registration date: Sunday September 23, 2012
Status: Moderator
Last seen: December 13, 2018

21
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.

Excel for Mac date formatting [Closed]

1 reply

Your reply

Subscribe To Our Newsletter!