Home

Date Formatting

%3CLINGO-SUB%20id%3D%22lingo-sub-722077%22%20slang%3D%22en-US%22%3EDate%20Formatting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-722077%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20trying%20to%20enter%20a%20date%20in%20a%20cell%20on%20excel.%20However%2C%20the%20cell%20is%20taking%20the%20date%20that%20I%20have%20entered%20as%20a%20formulae%20and%20converting%20it%20to%2001%2F01%2F1900%20the%20moment%20I%20press%20enter.%20How%20do%20I%20stop%20this%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-722077%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-722130%22%20slang%3D%22en-US%22%3ERe%3A%20Date%20Formatting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-722130%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F367073%22%20target%3D%22_blank%22%3E%40nikita2205%3C%2FA%3EHi%20Nikita%2C%20it%20may%20have%20to%20do%20with%20how%20the%20cell(s)%20are%20formatted.%20I%20use%20the%20option%20(obtained%20by%20right-clicking%20on%20it%2Fthem)%3A%20Format%20Cells...%20-%26gt%3B%20Custom%20-%26gt%3B%20dd%2Fmm%2Fyyyy%20(but%20this%20is%20mainly%20used%20in%20the%20UK).%3C%2FP%3E%3CP%3EHope%20this%20helps.%20Tony%3C%2FP%3E%3C%2FLINGO-BODY%3E
nikita2205
Occasional Visitor

I am trying to enter a date in a cell on excel. However, the cell is taking the date that I have entered as a formulae and converting it to 01/01/1900 the moment I press enter. How do I stop this?

1 Reply

@nikita2205Hi Nikita, it may have to do with how the cell(s) are formatted. I use the option (obtained by right-clicking on it/them): Format Cells... -> Custom -> dd/mm/yyyy (but this is mainly used in the UK).

Hope this helps. Tony

Related Conversations
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
Early preview of Microsoft Edge group policies
Sean Lyndersay in Discussions on
65 Replies
*Updated 9/3* Syncing in Microsoft Edge Preview Channels
Elliot Kirk in Articles on
201 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
2 Replies