decimal correction

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Sirs,
When a number with decimals is corrected to a required number of decimal
places,the multiplication of that number is giving incorrect
value(considering the decimal number prior to correction).Kindly advise any
method to rectify this?
Thanking you,
K.S.Warrier
 
Hi
formatting alone does not help :-)
Use something like
=ROUND(A1,2)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Change number from multiple decimals to 2 3
Access stripping decimal places in query 1
Trim varying decimals from column of numbers 9
Addition errors with Decimal Places 5
Decimal point in general format 1
if statement 3
how to correct the decimal number to the nearest even number 1
the decimals extends after the sum function 2

Back
Top