Excel Date formula issue
Hi
In Excel I want to include a date as only the month and year eg "Apr 2021". So I formatted it as this, but when I click in the formula bar I still see "4/1/2021". Does the day have to be included in the underlying value?
Thanks
Last Comment
ASKER
I can't provide a sample because it is confidential data. All I want to know is whether you can store only the Month and year in a cell without having to store the day
I don't know how the file gets populated, but so far, i see 3 options,
Option 1:
Use Format "mm yyyy"
Option 2:
Override the date with the value you want. Ex: "Apr 2021" by making sure to format the cell as Text
Option 3:
When you enter a date in the cell, without formatting it, add a " ' " before the value. This will set the value as text.
Ex: 'Apr 2021
Option 1:
Use Format "mm yyyy"
Option 2:
Override the date with the value you want. Ex: "Apr 2021" by making sure to format the cell as Text
Option 3:
When you enter a date in the cell, without formatting it, add a " ' " before the value. This will set the value as text.
Ex: 'Apr 2021
SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
thanks for the advice
Was the options i mentioned also part of one of the advices?
ASKER
Hi Wilder. Yes. Sorry I meant to click on yours too
Microsoft Excel
Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.
144K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
A format will never override the exact value of a cell. It will only display the way you want to see.
But just to be sure about the issue you have, can you provide a sample or a snapshot?