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.