Excel changes numbers (double-values) to dates

%3CLINGO-SUB%20id%3D%22lingo-sub-3353179%22%20slang%3D%22de-DE%22%3EExcel%20changes%20numbers%20(double-values)%20to%20dates%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3353179%22%20slang%3D%22de-DE%22%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Bildschirmfoto%202022-05-10%20um%2020.52.37.png%22%20style%3D%22width%3A%20776px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F370539i584DB41E4F5FDBDE%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Bildschirmfoto%202022-05-10%20um%2020.52.37.png%22%20alt%3D%22Screenshot%202022-05-10%20at%2020.52.37.png%22%20%2F%3E%3C%2FSPAN%3EHi!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EExcel%20changes%20my%20prices%20(double-values)%20to%20dates.%20I%20tried%20out%20every%20format%20in%20Excel%20to%20solve%20the%20problem%20(Standard%2C%20Date%2C%20Text%2C%20etc.)%20but%20nothing%20works%20out.%20When%20I%20use%20the%20format%20%22Standard%22%20I%20get%20totally%20wrong%20numbers%20that%20don't%20even%20look%20like%20my%20prices%2C%20f.ex.%2017.5%20Euro%20gets%20transformed%20to%2044765.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20hope%20anyone%20can%20help%20me.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EDaniel%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3353179%22%20slang%3D%22de-DE%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%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3355161%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20changes%20numbers%20(double-values)%20to%20dates%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3355161%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1386292%22%20target%3D%22_blank%22%3E%40daniel1385%3C%2FA%3E%26nbsp%3BThe%20number%2017.5%20is%20seen%20as%2017%20May%2C%20probably%20because%20your%20system%20is%20set%20up%20so%20that%20dates%20are%20used%20as%20dd.mm.yyyy%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EDates%20in%20Excel%20are%20sequential%20numbers%20starting%20at%201%20for%201%20January%201900.%2017%20May%202022%20has%20day%20number%2044698.%20The%20number%20you%20mentioned%20%3D%2023%20July%202022%2C%20so%20should%20show%20up%20when%20you%20enter%2023.7%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESince%20you%20are%20on%20a%20German%20system%20I%20believe%20you%20should%20enter%20prices%20with%20a%20comma%20rather%20than%20with%20a%20decimal%20point.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

Bildschirmfoto 2022-05-10 um 20.52.37.pngHi!

 

Excel changes my prices (double-values) to dates. I tried out every format in Excel to solve the problem (Standard, Date, Text, etc.) but nothing works out. When I use the format "Standard" I get totally wrong numbers that don't even look like my prices, f.ex. 17.5 Euro gets transformed to 44765. 

 

I hope anyone can help me.

 

Daniel

1 Reply

@daniel1385 The number 17.5 is seen as 17 May, probably because your system is set up so that dates are used as dd.mm.yyyy

 

Dates in Excel are sequential numbers starting at 1 for 1 January 1900. 17 May 2022 has day number 44698. The number you mentioned = 23 July 2022, so should show up when you enter 23.7

 

Since you are on a German system I believe you should enter prices with a comma rather than with a decimal point.