Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Set fixed Decimal places with no rounding
Hi.
Im trying to cut off the extra decimal places. i only want it to be 1dp or 2dp depending on the place. I used the LEFT function for the whole numbers, and played with the =FIXED(A1,1) but this rounds the numbers. Basically I want 90.789 to = '90.7'. 90.3985=90.3 90.333 = 90.3 The number is a result of a calculation. Thanks. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Set fixed Decimal places with no rounding
On Jul 3, 8:33*pm, azza wrote:
Hi. Im trying to cut off the extra decimal places. *i only want it to be 1dp or 2dp depending on the place. I used the LEFT function for the whole numbers, and played with the =FIXED(A1,1) but this rounds the numbers. Basically I want 90.789 to = '90.7'. * * *90.3985=90.3 * * *90.333 = 90.3 The number is a result of a calculation. Thanks. TRUNC( 90.789, 1) = 90.7 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Set fixed Decimal places with no rounding
Fantastic.
Had tobe something simple. It does not seem to let me to different number of dp though. ie 90.7898 = 90.78 even after changing the no of digits to 2.... Thanks. "recrit" wrote: On Jul 3, 8:33 pm, azza wrote: Hi. Im trying to cut off the extra decimal places. i only want it to be 1dp or 2dp depending on the place. I used the LEFT function for the whole numbers, and played with the =FIXED(A1,1) but this rounds the numbers. Basically I want 90.789 to = '90.7'. 90.3985=90.3 90.333 = 90.3 The number is a result of a calculation. Thanks. TRUNC( 90.789, 1) = 90.7 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Set fixed Decimal places with no rounding
"90.7898 = 90.78 even after changing the no of digits to 2"
Isn't that what you want? Regards, Fred. "azza" wrote in message ... Fantastic. Had tobe something simple. It does not seem to let me to different number of dp though. ie 90.7898 = 90.78 even after changing the no of digits to 2.... Thanks. "recrit" wrote: On Jul 3, 8:33 pm, azza wrote: Hi. Im trying to cut off the extra decimal places. i only want it to be 1dp or 2dp depending on the place. I used the LEFT function for the whole numbers, and played with the =FIXED(A1,1) but this rounds the numbers. Basically I want 90.789 to = '90.7'. 90.3985=90.3 90.333 = 90.3 The number is a result of a calculation. Thanks. TRUNC( 90.789, 1) = 90.7 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Set fixed Decimal places with no rounding
Sweet.... Found the problem, there was formatting on the cell.. Changed it
back to General and it works. Thanks heaps. "Fred Smith" wrote: "90.7898 = 90.78 even after changing the no of digits to 2" Isn't that what you want? Regards, Fred. "azza" wrote in message ... Fantastic. Had tobe something simple. It does not seem to let me to different number of dp though. ie 90.7898 = 90.78 even after changing the no of digits to 2.... Thanks. "recrit" wrote: On Jul 3, 8:33 pm, azza wrote: Hi. Im trying to cut off the extra decimal places. i only want it to be 1dp or 2dp depending on the place. I used the LEFT function for the whole numbers, and played with the =FIXED(A1,1) but this rounds the numbers. Basically I want 90.789 to = '90.7'. 90.3985=90.3 90.333 = 90.3 The number is a result of a calculation. Thanks. TRUNC( 90.789, 1) = 90.7 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data validation with a fixed amount of decimal places | Excel Worksheet Functions | |||
Data validation with a fixed amount of decimal places | Excel Worksheet Functions | |||
Want Fixed Decimal places in only 1 column | Excel Discussion (Misc queries) | |||
tools|options|Edit tab|fixed decimal places | Excel Discussion (Misc queries) | |||
FIXED 2 DECIMAL PLACES, MUST ENTER ALL ZEROES AFTER DECIMAL POINT. | Excel Discussion (Misc queries) |