Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi all,
I have a fairly mysterious problem. It is hard to explain here, but basically what I did is declare a variable X as single, then assign a cell content containing decimal digits to X, then write X back to another cell. Problem is, let say, suppose the original cell contains 0.0111773. After transferring this number to X and then copy back to another cell, that cell now contains 0.0111772995442152. Though the cell content is very near to the original one, but it does cause problem to me. Anybody can guess what actually happened and what is the solution? Thanks a lot. Frederick Chow |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Unacceptable floating point errors | Excel Discussion (Misc queries) | |||
Convert floating point to Hours and Minutes ?? | Excel Discussion (Misc queries) | |||
setting a floating decimel point | New Users to Excel | |||
Floating Point Functions | Excel Programming | |||
Handle Floating point rounding errors, efficiently | Excel Programming |