View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
programinfinity programinfinity is offline
external usenet poster
 
Posts: 3
Default Prevent scientific formatting when creating excel sheet from vbscr

Hi,
I'm trying to create an excel sheet using html <table tags from vbscript.
One of the columns contains numbers 14 digits long. On opening the file
created it shows the numbers as 2.3024E+13.
I tried adding an apostrophe ( ' ) before the number. But sadly the
apostrophe also shows on the excel sheet.
How can I prevent the number to convert to scientific format and display all
14 digits either as number or text?

Thanks in advance,
programinfinity