Home 
Search 
Today's Posts 
#1




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




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




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




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




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




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




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 2decimal place numbers gives result 13decimal 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 commadecimal to perioddecimal  Excel Discussion (Misc queries)  
Converting 2place 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) 