View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Don Guillett Don Guillett is offline
external usenet poster
 
Posts: 10,124
Default Copy & Paste value Function

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