View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
dazman[_16_] dazman[_16_] is offline
external usenet poster
 
Posts: 1
Default .value only to 2 dp?


Hi,

I have some cells in my worksheet that are numbers to 4 dp. I'm copying
them to other cells using

Me.Cells(3, 2).Value = Me.Cells(4, 2).Value

However the resultant values in the new cells are only to 2 dp (and I
get rounding errors), when the column has been set to always be 4dp.

Anyone have any idea as to a solution? Thanks, Daz


--
dazman
------------------------------------------------------------------------
dazman's Profile: http://www.excelforum.com/member.php...o&userid=25903
View this thread: http://www.excelforum.com/showthread...hreadid=495438