May 10 2022 12:11 PM - edited May 10 2022 12:12 PM
Hi!
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
May 10 2022 10:11 PM
@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.