**Question description:**

*This user has given permission to use the problem statement for this blog.*

if i calculate 1,486 x 10=1486
if i calculate1,4 x 10=14
What is wrong

Solved by F. Q. in 20 mins

This is the chat thread from the real Excelchat help session. It contains no private user information.

Excelchat Expert
28/05/2018 - 06:46

HI

User
28/05/2018 - 06:46

hi

Excelchat Expert
28/05/2018 - 06:46

It's pleasure to help you today.

Excelchat Expert
28/05/2018 - 06:46

I have referred your querey.

Excelchat Expert
28/05/2018 - 06:47

Can you please enter the following in the preview.

Excelchat Expert
28/05/2018 - 06:47

I will review them.

Excelchat Expert
28/05/2018 - 06:48

It is a different value. 14860.

Excelchat Expert
28/05/2018 - 06:48

How did you achieve 1486 only?

Excelchat Expert
28/05/2018 - 06:49

when you add comma, it is treated as text.

Excelchat Expert
28/05/2018 - 06:49

I have converted them to 1.48 instead.

User
28/05/2018 - 06:50

if i have three or more then its wrong

Excelchat Expert
28/05/2018 - 06:50

And there is a format, where comma can be added in thousand place.

Excelchat Expert
28/05/2018 - 06:50

that is not treated as text.

Excelchat Expert
28/05/2018 - 06:51

It is consider as number.

Excelchat Expert
28/05/2018 - 06:51

So, please check whether it is comma used as text or number format. Mostly it is number format, as you are multiplying with another number.

User
28/05/2018 - 06:52

why is it correct when using 1,4 & 1,48 bur wrong when using 1,486

Excelchat Expert
28/05/2018 - 06:53

1,48 can't be there.

Excelchat Expert
28/05/2018 - 06:53

As comma is used in thousand place.

Excelchat Expert
28/05/2018 - 06:53

1.48 is dot.

User
28/05/2018 - 06:54

ok thanks

Excelchat Expert
28/05/2018 - 06:54

You are welcome.

Excelchat Expert
28/05/2018 - 06:54

Please visit Got IT Pro.

Excelchat Expert
28/05/2018 - 06:54

Have a great day ahead. Please leave great review after ending the session.

User
28/05/2018 - 06:54

ok

**This is the output file from the real Excelchat help session:**

*This is an example of the expert help you can get. It contains no private user information.*