simple problem with values in cells
Hi all,
I use the following code to fill some values into cells
Range("CA6").Select
Range("CA6") = "3.2745"
Range("CA7").Select
Range("CA7") = "8.9355"
Range("CA8").Select
Range("CA8") = "8.9355"
Range("CA9").Select
Range("CA9") = "13.875"
Range("CA10").Select
Range("CA10") = "4.440"
Range("CA11").Select
Range("CA11") = "6.660"
-and more code-
everything works, but in cell CA6 I get 32745 and in cell CA7 I get 89355
:-(
The CA8 values is 8,9355 - what 's right :-)
The format of all cells are the same.
What can I do to geet also the both values in CA6 and CA7 in the right way ?
When I let a macro with specialy this part of code separatly it will works
?!?!
I use WINN XXP and XL2000 with SP3
Thanks for help ... joachim
|