Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old July 3rd 07, 03:40 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: May 2007
Posts: 10
Default 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   Report Post  
Old July 3rd 07, 04:02 PM posted to microsoft.public.excel.misc
ed ed is offline
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 82
Default 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   Report Post  
Old July 4th 07, 11:04 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 7,247
Default 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   Report Post  
Old July 4th 07, 11:25 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 2,345
Default 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   Report Post  
Old July 5th 07, 12:26 AM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 8,856
Default 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   Report Post  
Old July 5th 07, 12:45 AM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 2,345
Default 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   Report Post  
Old July 5th 07, 01:21 AM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 8,856
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Subtracting two 2-decimal place numbers gives result 13-decimal places? [email protected] Excel Worksheet Functions 5 March 12th 07 11:38 PM
How can I sort mostly 3 decimal with some 4 decimal numbers PeterM Excel Discussion (Misc queries) 4 August 16th 06 02:15 AM
Batch converting CSV files from comma-decimal to period-decimal Nodles Excel Discussion (Misc queries) 3 July 5th 06 06:57 PM
Converting 2-place decimal value to floating point decimal number with leading zero Kermit Piper Excel Discussion (Misc queries) 3 March 18th 06 07:20 PM
FIXED 2 DECIMAL PLACES, MUST ENTER ALL ZEROES AFTER DECIMAL POINT. SUKYKITTY Excel Discussion (Misc queries) 3 July 6th 05 01:50 PM


All times are GMT +1. The time now is 06:42 PM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017