W
W
WebforSelf2021-06-10 14:19:34
excel
WebforSelf, 2021-06-10 14:19:34

Problem with pricing in excel?

I have a CSV file that I open with Excel.
The problem is this, for example, the price of the goods there is 3.10 (three rubles 10 kopecks)
He makes me a field on 10/03/2021 (Oct. 21)

And changing the format does not help, then my 3.10 r is remade into

44472.00 it all prices in the format 3.10 - what to do?
60c1f58a95392674375185.png

Answer the question

In order to leave comments, you need to log in

1 answer(s)
H
hint000, 2021-06-10
@hint000

The answer is about the same as here (change the decimal separator):
Why is it so difficult to convert from xlsx to csv using excel?

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question