number format change
Hi
While running a macro my number formats changes to scientific notation as follows 08E000123 changes to 8.00E+123 and 08E000012 changes to 8.00E+12 while 08E001234 stays as 08E001234. Its like if there is more than 2 zeros after the E the number changes to scientific notation. How can I stop this in the Macro. Thanks Eddie |
number format change
Sub mikerobe()
Dim x As String x = "08E000123" End Sub -- Gary''s Student - gsnu2007j |
All times are GMT +1. The time now is 08:03 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com