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



Posted by Celia on September 21, 2000 5:53 PM


Alex
If all you want to do is display "1E00", then format the cell as text.
Celia