View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dinesh Dinesh is offline
external usenet poster
 
Posts: 103
Default Copy & Paste value Function

Hi don, After formatting, visibly there are only two decimals, but when you
click on the cell, it has more than two decimals. How do I truncate the more
than two deicmal points?

"Don Guillett" wrote:

Just pre-format the cell(s)

--
Don Guillett
SalesAid Software

"Dinesh" wrote in message
...
When Copy and Paste Value, I get numbers in 6 to 7 numbers from decimal
points. Meaning it will post the value for example xx.xxxxxx. Is there a
way
that I can paste the value by two decimal points only. Again for example
xx.xx instead of xx.xxxxxx.

Thanks in advance for the solution.

DS