Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
remova of decimal palces
Hi, I am trying to make my figure e.g 123,456.78 to be 123,456. I do not want
to see the decimal place and I don't want it to round it up to be 123,457. Anyone can tell me what formula to use? Thanks Olu |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
remova of decimal palces
On Jul 3, 9:40 am, oasalako1
wrote: Hi, I am trying to make my figure e.g 123,456.78 to be 123,456. I do not want to see the decimal place and I don't want it to round it up to be 123,457. Anyone can tell me what formula to use? Thanks Olu Try =ROUNDDOWN(123456.78,0) |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
remova of decimal palces
Olu,
Use a formula like: =FLOOR(ABS(A1),1)*SIGN(A1) -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting www.cpearson.com (email on the web site) "oasalako1" wrote in message ... Hi, I am trying to make my figure e.g 123,456.78 to be 123,456. I do not want to see the decimal place and I don't want it to round it up to be 123,457. Anyone can tell me what formula to use? Thanks Olu |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
remova of decimal palces
Chip,
May I ask why not: =FLOOR(A1,SIGN(A1)) or even: =TRUNC(A1) Which as far as I can see return the same result. -- Regards, Sandy In Perth, the ancient capital of Scotland and the crowning place of kings Replace @mailinator.com with @tiscali.co.uk "Chip Pearson" wrote in message ... Olu, Use a formula like: =FLOOR(ABS(A1),1)*SIGN(A1) -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting www.cpearson.com (email on the web site) "oasalako1" wrote in message ... Hi, I am trying to make my figure e.g 123,456.78 to be 123,456. I do not want to see the decimal place and I don't want it to round it up to be 123,457. Anyone can tell me what formula to use? Thanks Olu |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
remova of decimal palces
You could use:
=INT(A1) Hope this helps. Pete On Jul 3, 3:40 pm, oasalako1 wrote: Hi, I am trying to make my figure e.g 123,456.78 to be 123,456. I do not want to see the decimal place and I don't want it to round it up to be 123,457. Anyone can tell me what formula to use? Thanks Olu |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
remova of decimal palces
You could use:
=INT(A1) Unless A1 is negative whereupon -123,456.78 will become -123,347 which I assume the OP does not want. -- Regards, Sandy In Perth, the ancient capital of Scotland and the crowning place of kings Replace @mailinator.com with @tiscali.co.uk "Pete_UK" wrote in message ups.com... You could use: =INT(A1) Hope this helps. Pete On Jul 3, 3:40 pm, oasalako1 wrote: Hi, I am trying to make my figure e.g 123,456.78 to be 123,456. I do not want to see the decimal place and I don't want it to round it up to be 123,457. Anyone can tell me what formula to use? Thanks Olu |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
remova of decimal palces
The OP didn't mention anything about negative numbers !!
Pete On Jul 5, 12:45 am, "Sandy Mann" wrote: You could use: =INT(A1) Unless A1 is negative whereupon -123,456.78 will become -123,347 which I assume the OP does not want. -- Regards, Sandy In Perth, the ancient capital of Scotland and the crowning place of kings Replace @mailinator.com with @tiscali.co.uk "Pete_UK" wrote in message ups.com... You could use: =INT(A1) Hope this helps. Pete On Jul 3, 3:40 pm, oasalako1 wrote: Hi, I am trying to make my figure e.g 123,456.78 to be 123,456. I do not want to see the decimal place and I don't want it to round it up to be 123,457. Anyone can tell me what formula to use? Thanks Olu- Hide quoted text - - Show quoted text - |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Subtracting two 2-decimal place numbers gives result 13-decimal places? | Excel Worksheet Functions | |||
How can I sort mostly 3 decimal with some 4 decimal numbers | Excel Discussion (Misc queries) | |||
Batch converting CSV files from comma-decimal to period-decimal | Excel Discussion (Misc queries) | |||
Converting 2-place decimal value to floating point decimal number with leading zero | Excel Discussion (Misc queries) | |||
FIXED 2 DECIMAL PLACES, MUST ENTER ALL ZEROES AFTER DECIMAL POINT. | Excel Discussion (Misc queries) |