Excel Bug
Posted by Alex on September 21, 2000 2:09 PM
Hi!
I want to put a Hex value "1E00" to excel cell by using Visual Basic (VBA).
I used the following command, but I got "1.00E+00" not "1E00".
------------------------------------------------
OutputSheet.Range("A2", "A2").Value = "1E00"
OutputSheet.Range("A3", "A3").Value = "1E" + "00"
OutputSheet.Range("A4", "A4").Value = Hex(7680)
OutputSheet.Range("A5", "A5").Value = Hex$(7680)
OutputSheet.Cells(6, 6) = "1E00"
OutputSheet.Cells(6, 6) = Hex(7680)
--------------------------------------------
This is Excel Bug. Any one can tell me how to put "1E00" in Excel cell.
Thanks!
Alex