View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Halray Halray is offline
external usenet poster
 
Posts: 14
Default Number variable loses format on write

Have have a varibale declared as a double, read a number into it from a file.
THe variable is indicated with four decimal places when viewed in the
debugger. When I write the variable out to Excel using the following the
number gets truncated to two decimal places:

With ActiveWorkbook.Worksheets("Dump Area")
.Cells(RowNumber, 2) = AreaCounts

Anyone have any suggestions to fix this problem?

Thanks !



--
Ray