Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Using Excel 2002 and VB6.3
I type just four numbers 1, 8, 5 and 2. That is 1852 in A1. NO FORMATS AT ALL. JUST FOUR NUMBERS. A ------------- 1 | 1852 | ------------- I use VBA Immediate Window to do the following ? Range("A1").Value 1852.00034359738 <<<< Load of crap. and it returns some unnecessary numbers after the decimal point. --- Using Excel 2000 and VB6.0 I do the same thing... ? Range("A1").Value 1852 <<< Works as expected ---- I am very much annoyed with this behaviour as I have to export lots of these values to an access database and each of those values are garbled after the decimal point. Can someone please explain the reason for this strange behaviour? This problem is strangely new to me as I haven't experienced this before. Is it 1) a bug in the version of excel or vba (or) 2) a configuration thingy? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
"Abnormal behaviour" data entry form | Excel Discussion (Misc queries) | |||
Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel | |||
Strange "FormatCells" behaviour | Excel Worksheet Functions | |||
Behaviour of "Replace" | Excel Programming |