Date en general notation

%3CLINGO-SUB%20id%3D%22lingo-sub-1369304%22%20slang%3D%22en-US%22%3EDate%20en%20general%20notation%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1369304%22%20slang%3D%22en-US%22%3EHi%20all%2C%3CBR%20%2F%3E%3CBR%20%2F%3EWho%20can%20help%20me%3F%20I%20have%20a%20set%20with%20data%20and%20the%20dates%20are%20formatted%20general%20and%20they%20are%20displayed%20as%2001%2F01%2F2020%2C%2001%2F02%2F2020%2C%2001%2F03%2F2020.%20Now%20I%20would%20like%20to%20add%20the%20new%20date%20%E2%80%9801%2F04%2F2020%E2%80%99%20in%20general%20format.%20So%2C%20I%20don%E2%80%99t%20want%20it%20to%20be%20formatted%20as%20a%20date!%3CBR%20%2F%3EWhenever%20I%20click%20enter%20it%20changes%20to%20a%20date%20format%20and%20when%20I%20change%20it%20back%20to%20a%20general%20format%2C%20I%20changes%20into%20a%20number....%3CBR%20%2F%3EWho%20can%20help%20me%20so%20the%20date%20is%20stated%20in%20a%20general%20format%20and%20like%2001%2F04%2F2020%3F%3CBR%20%2F%3E%3CBR%20%2F%3EThank%20you%20%3CSPAN%20class%3D%22lia-unicode-emoji%22%20title%3D%22%3Afolded_hands%3A%22%3E%3Afolded_hands%3A%3C%2FSPAN%3E%F0%9F%8F%BC%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1369304%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1369332%22%20slang%3D%22en-US%22%3ERe%3A%20Date%20en%20general%20notation%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1369332%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F659290%22%20target%3D%22_blank%22%3E%40Gaill350%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EDate%20and%20time%20in%20Excel%20are%20actual%20numbers%20where%201%20is%20equal%20to%20Jan%2001%2C%201900%20and%20time%20is%20decimal%20part%20of%20the%20number.%20You%20may%20show%20such%20numbers%20as%20dates%20by%20applying%20to%20them%20date%20and%20or%20time%20format.%20In%20General%20format%20they%20will%20be%20shown%20as%20numbers.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EMost%20probably%20what%20you%20see%20as%20dates%20in%20General%20format%20actually%20are%20texts%20which%20present%20the%20dates.%20Not%20the%20dates%20themselves.%20For%20the%20texts%20format%20doesn't%20matter.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor
Hi all,

Who can help me? I have a set with data and the dates are formatted general and they are displayed as 01/01/2020, 01/02/2020, 01/03/2020. Now I would like to add the new date ‘01/04/2020’ in general format. So, I don’t want it to be formatted as a date!
Whenever I click enter it changes to a date format and when I change it back to a general format, I changes into a number....
Who can help me so the date is stated in a general format and like 01/04/2020?

Thank you
1 Reply

@Gaill350 

Date and time in Excel are actual numbers where 1 is equal to Jan 01, 1900 and time is decimal part of the number. You may show such numbers as dates by applying to them date and or time format. In General format they will be shown as numbers.

 

Most probably what you see as dates in General format actually are texts which present the dates. Not the dates themselves. For the texts format doesn't matter.