| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to write 1234567890123456789 into a cell with number format | Excel Discussion (Misc queries) | |||
| number entered in cell loses trailing zeros in formula bar | Excel Discussion (Misc queries) | |||
| variable number format in cell | Excel Discussion (Misc queries) | |||
| webquery loses format of leading zero and to scientific | Excel Programming | |||
| Passing Number Format to a Variable | Excel Programming | |||
Threaded Mode
