I want excel to show me date in the form of yyyy.mm without showing 01/01/YYYY in the tab.

**murgiax** · 07-14-2016, 02:22 PM

Hi,

I would appreciate if you could give me a command that lets me view the date as YYYY.MM ( 1990.01) in the column as well the tab when i double click it.

Thank you

**TMS** · 07-14-2016, 02:29 PM

If it's a date, it's a date. What is displayed is dependent on the formatting BUT the underlying value is a number representing the number of days from 00/01/1900, that is, 01/01/1900 is represented by a 1.

If it doesn't look like a date in the formula bar (when formatted as a Date) it is not a date. And, if it looks like a date when the cell is formatted as General, it is not a date.

**murgiax** · 07-14-2016, 02:33 PM

Hello, thank you for the quick reply. It does show as a date, but, I can remove year from the data and not the day of the week. Is it possible to edit my data in a way that i view only month and year in the format YYYY.MM without day appearing in the formula bar?

Thank you

**TMS** · 07-14-2016, 06:36 PM

No, not as far as I am aware. You could switch off the formula bar so it doesn't show anything.

I want excel to show me date in the form of yyyy.mm without showing 01/01/YYYY in the tab.

LinkBack

Thread Tools

Rate This Thread

Display

I want excel to show me date in the form of yyyy.mm without showing 01/01/YYYY in the tab.

Re: I want excel to show me date in the form of yyyy.mm without showing 01/01/YYYY in the

Re: I want excel to show me date in the form of yyyy.mm without showing 01/01/YYYY in the

Re: I want excel to show me date in the form of yyyy.mm without showing 01/01/YYYY in the

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Date format will not show as dd-mmm-yyyy but show as mm/dd/yyyy

User Form changes date from dd/mm/yyyy to mm/dd/yyyy On Spreadsheet

VBA Macro to capture DATA in dd/mm/yyyy even though system date format is mm/dd/yyyy

[SOLVED] Imported data contains strings dd.mm.yyyy how can I convert to date format dd/mm/yyyy inVB

Copy+Paste macro dd/mm/yyyy to dd/mm/yyyy and NOT dd/mm/yyyy to mm/dd/yyyy

[SOLVED] how do I change date from mm/dd/yyyy to dd:mm:yyyy format in Excel

[SOLVED] opening excel file -> date format problem: DD/MM/YYYY vs MM/DD/YYYY

Bookmarks

Bookmarks

Posting Permissions