Number variable loses format on write
- From: Halray <Halray@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Thu, 25 Aug 2005 12:13:07 -0700
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
.
- Follow-Ups:
- Re: Number variable loses format on write
- From: Doug Glancy
- Re: Number variable loses format on write
- From: Dave Peterson
- Re: Number variable loses format on write
- Prev by Date: Re: Import From with macro
- Next by Date: Re: DataType Property
- Previous by thread: Search range add value
- Next by thread: Re: Number variable loses format on write
- Index(es):