ExcelBanter - Want to Past without Percentage Zero

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Want to Past without Percentage Zero (https://www.excelbanter.com/excel-discussion-misc-queries/128741-want-past-without-percentage-zero.html)

Qazi Ahmad

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.

Mike

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.

All times are GMT +1. The time now is 05:00 AM.