Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old November 15th 16, 03:52 PM
Junior Member
 
First recorded activity by ExcelBanter: Nov 2016
Posts: 1
Default Prevent rounding up and down

Hi

I have a table of data which has a series of percentages. The client wants these % displayed to 0 decimal places. However, Excel rounds anything 99.5% and above to 100% and 0.4% and below to 0%.

Is there any way of displaying those as 99% and 1% without affecting the rest of the data or changing the decimal places?

Thanks
Terry

  #2   Report Post  
Old November 15th 16, 06:17 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Apr 2015
Posts: 763
Default Prevent rounding up and down

Hi

I have a table of data which has a series of percentages. The client
wants these % displayed to 0 decimal places. However, Excel rounds
anything 99.5% and above to 100% and 0.4% and below to 0%.

Is there any way of displaying those as 99% and 1% without affecting
the rest of the data or changing the decimal places?

Thanks
Terry


Set the NumberFormat to zero decimal places, perhaps!

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion
  #3   Report Post  
Old November 15th 16, 06:34 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Apr 2011
Posts: 3,536
Default Prevent rounding up and down

Hi Terry,

Am Tue, 15 Nov 2016 14:52:11 +0000 schrieb TerrySmith33:

I have a table of data which has a series of percentages. The client
wants these % displayed to 0 decimal places. However, Excel rounds
anything 99.5% and above to 100% and 0.4% and below to 0%.

Is there any way of displaying those as 99% and 1% without affecting the
rest of the data or changing the decimal places?


try a custom number format:
[<=0.004]1%;[=0.995]99%;0%


Regards
Claus B.
--
Windows10
Office 2016


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
prevent user from deleting a tab prevent running macro from menu joemeshuggah Excel Programming 5 February 25th 10 11:58 PM
Prevent EXCEL from rounding the result of a calculation elusiverunner Excel Discussion (Misc queries) 3 January 9th 08 09:38 AM
HOW CAN I PREVENT EXCEL FILES FROM BEING DELETED OR PREVENT TRASH ROB Excel Discussion (Misc queries) 2 April 2nd 07 01:13 PM
prevent rounding up jhahes[_51_] Excel Programming 1 March 23rd 06 08:36 PM
HOW TO PREVENT NUMBERS IN SPREAD SHEET FROM ROUNDING BSA New Users to Excel 1 October 19th 05 06:26 PM


All times are GMT +1. The time now is 05:37 PM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017