| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
decimal correction
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 |
|
#2
|
|||
|
|||
|
Hi
formatting alone does not help :-) Use something like =ROUND(A1,2) -- Regards Frank Kabel Frankfurt, Germany "K.S.Warrier" schrieb im Newsbeitrag ... 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 |
|
#3
|
|||
|
|||
|
Hi, Thank you for your immediate response. Regards, K.S.Warrier "Frank Kabel" wrote: Hi formatting alone does not help :-) Use something like =ROUND(A1,2) -- Regards Frank Kabel Frankfurt, Germany "K.S.Warrier" schrieb im Newsbeitrag ... 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| ROUND DATA TO 2 DECIMAL PLACES | New Users to Excel | |||
| decimal point override does not work | Excel Discussion (Misc queries) | |||
| Format a worksheet to carry out all calculations to 2 decimal plac | Excel Discussion (Misc queries) | |||
| Format a worksheet to carry out all calculations to 2 decimal plac | Excel Discussion (Misc queries) | |||
| how to convert total hours (HH:MM) into decimal number | Excel Worksheet Functions | |||
Linear Mode
