Problem with excel not recognising decimals in formula/date formatting issue

%3CLINGO-SUB%20id%3D%22lingo-sub-2326023%22%20slang%3D%22en-US%22%3EProblem%20with%20excel%20not%20recognising%20decimals%20in%20formula%2Fdate%20formatting%20issue%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2326023%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20need%20some%20urgent%20help!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EToday%20my%20excel%20has%20started%20turning%20all%20decimal%20points%20to%20dates.%20It%20isn't%20recognising%20decimal%20points%20in%20cells%20or%20when%20included%20as%20part%20of%20a%20formula.%20I%20have%20formatted%20the%20cells%20for%20numbers%2C%20but%20it%20isn't%20helping.%20In%20cells%20where%20I%20want%20decimals%2C%20excel%20is%20turning%20them%20in%20to%20number%20date%20sequences%20(i.e.%206.5%20becomes%2044322)%2C%20and%20even%20within%20a%20formula%20in%20a%20cell%2C%20excel%20isn't%20recognising%20the%20decimal%20points%20as%20part%20of%20the%20formula%20because%20it%20is%20assuming%20it's%20a%20date.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20not%20an%20excel%20wizard%20by%20a%20long%20shot%2C%20I%20have%20googled%20everything%2C%20tried%20what%20I%20know%20and%20nothing%20seems%20to%20be%20working.%20It%20is%20almost%20as%20if%20the%20file%20has%20a%20master%20setting%20put%20on%20it%20to%20format%20everything%20as%20a%20date%2C%20regardless%20of%20the%20format%20of%20the%20specific%20cell.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECan%20anyone%20please%20help%3F%20I'm%20at%20my%20wits%20end!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2326023%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20on%20Mac%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2326413%22%20slang%3D%22en-US%22%3ERe%3A%20Problem%20with%20excel%20not%20recognising%20decimals%20in%20formula%2Fdate%20formatting%20issue%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2326413%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1045696%22%20target%3D%22_blank%22%3E%40Scott1200%3C%2FA%3E%26nbsp%3BYour%20Excel%20recognises%206.5%20as%206%20May%20(%3D%20day%20number%2044322).%20Have%20you%2C%20by%20any%20chance%2C%20recently%20updated%20your%20MacOS%20that%2C%20perhaps%20accentually%20changed%20language%20and%20regional%20settings%20(under%20Apple%20logo%2C%20System%20Preferences...%2C%20Language%20%26amp%3B%20Region%2C%20Advance...%2C%20Dates%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

Hello,

 

I need some urgent help!

 

Today my excel has started turning all decimal points to dates. It isn't recognising decimal points in cells or when included as part of a formula. I have formatted the cells for numbers, but it isn't helping. In cells where I want decimals, excel is turning them in to number date sequences (i.e. 6.5 becomes 44322), and even within a formula in a cell, excel isn't recognising the decimal points as part of the formula because it is assuming it's a date. 

 

I'm not an excel wizard by a long shot, I have googled everything, tried what I know and nothing seems to be working. It is almost as if the file has a master setting put on it to format everything as a date, regardless of the format of the specific cell. 

 

Can anyone please help? I'm at my wits end!

1 Reply

@Scott1200 Your Excel recognises 6.5 as 6 May (= day number 44322). Have you, by any chance, recently updated your MacOS that, perhaps accidentally changed language and regional settings (under Apple logo, System Preferences..., Language & Region, Advanced..., Dates?

And check the number settings as well. If the decimal point is seen as a date separator, your decimal "point" me be a comma.