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

Thanks, Peo works very well.

"Peo Sjoblom" wrote:

You can use precision as displayed under toolsoptionscalculation


--


Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com



"Dinesh" wrote in message
...
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