vba - Numbers in an Excel column created using VB6 defaulting to scientific notation -


kindly me solve below issue.

issue:

using vb 6.0 code, excel file generated. column in excel file should have 20-digit number. while opening excel file, showing 2.00575e+15.

please share ideas solve issue. think if can format field text, issue resolved. have tried following code part also.. no positive result.

  1. myexcelsheet.range("a1","a10").numberformat = "@"
  2. myexcelsheet.range("a1","a10").numberformat = "text"

neither works though.


Comments

Popular posts from this blog

php - regexp cyrillic filename not matches -

c# - OpenXML hanging while writing elements -

sql - Select Query has unexpected multiple records (MS Access) -