Thread
:
Copy & Paste value Function
View Single Post
#
4
Posted to microsoft.public.excel.worksheet.functions
Dinesh
external usenet poster
Posts: 103
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
Reply With Quote
Dinesh
View Public Profile
Find all posts by Dinesh