Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 32
Default Want to Past without Percentage Zero

One Cell I have formula with percentage, when I copy and use past special
option the Result come with .00 I want to copy and past any percentage cell
figures without percent (.00) I want just round Figurs not with .00.
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3,101
Default Want to Past without Percentage Zero

Format the cell to have no decimal places

"Qazi Ahmad" wrote:

One Cell I have formula with percentage, when I copy and use past special
option the Result come with .00 I want to copy and past any percentage cell
figures without percent (.00) I want just round Figurs not with .00.

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
Calculating a percentage with the end percentage in mind Shadowshady Excel Discussion (Misc queries) 2 June 17th 06 09:41 AM
Displaying percentage in ranges in pivot table pamarty Excel Worksheet Functions 3 May 10th 06 09:54 PM
Report that display percentage below certain level TSS Excel Discussion (Misc queries) 1 September 1st 05 04:56 PM
Percentage Calculation clandis Excel Worksheet Functions 5 July 21st 05 07:38 PM
Formatting percentage signs in Excel Romany Excel Discussion (Misc queries) 3 June 1st 05 07:02 PM


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

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

About Us

"It's about Microsoft Excel"