| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel strange (erroneous?) decimal behaviour
Cell A1 = 4.469 with 3 decimals numeric format
if cell A2 formula is "=A1" == A2 = 4.469 if in VBA: Range("A2").Value=Range("A1").Value == A2 = 4.470 if in VBA: Range("A2").Value=Range("A1").Value * 1000 / 1000 == A2 = 4.469 Can anyone explain this please and how to avoid it?? Could it be that there is a SET DECIMALS TO 2 VBA environment setting that causes a 2-decimal rounding?? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| strange behaviour in Excel 2003 when importing XML | Excel Discussion (Misc queries) | |||
| Strange behaviour - loading Excel clears Clipboard | Excel Discussion (Misc queries) | |||
| Strange VBA Behaviour | Excel Programming | |||
| Is there a maximum number of Add-ins allowed? - strange Excel behaviour | Excel Programming | |||
| Strange behaviour in VBA Help | Excel Programming | |||
Threaded Mode
