Previous Topic Next Topic

Excel for Mac date formatting

Closed
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
Member
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

1 reply

Answer 1 / 1
Zohaib R
Posts
2368
Registration date
Sunday September 23, 2012
Status
Member
Last seen
December 13, 2018
 69
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.
0