Re: Number variable loses format on write

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

If you look in the formulabar, do you see all 4 decimals?

If yes, try widening the column.

If no, what value do you see in the debugger and what value do you see in the
formulabar?

Halray wrote:
>
> 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

--

Dave Peterson
.

Quantcast