Prevent scientific formatting when creating excel sheet from vbscr

[programinfinity]

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

 

[Jacob Skaria]

Format the column to Text before placing the text

Range("A:A").NumberFormat = "@"

If this post helps click Yes

 

[programinfinity]

thanks for the reply,
the excel sheet is also newly created by the vbscript so i cannot format the
column before. is there something I can set in the column properties while
writing out the excel file the same way I can set widths - like using
'mso-width-source:userset;mso-width-alt:3754;width:105pt'?

i need to email out the excel sheet from the script so I can't edit and
change the format either.

- programinfinity

 

[Tim Williams]

<table>
<tr>
<td style='mso-number-format:\@;'>12345678912345667</td>
</tr>
</table>

Tim

 

[programinfinity]

Thank you! It worked perfectly.

- programinfinity

 

[Tim Williams]

No problem.

The easiest way to get the correct style is to format cells in an Excel
sheet, save as HTML, and inspect the source for the styles.


Tim