Format Numbers in Excel Page 1

[TWillard]

I am writing an excel page in ASP using vbScript. The contents of the excel page are being pulled from a database. Currently, excel treats all cells whose contents are numeric as type numeric. Because of this fact, large numbers are converted into scientific notation.

I want to be able to enter numbers and not have them treated as numeric and not turned into scientific notation. I am currently using the CLEAN() function of excel. This will work to convert the input into text for a cell. However, you are left with "CLEAN(1234567890)" in excel's address bar. Is their anyway to format the cell into type text before the number is written in ASP? Or does anyone have any good suggestions on how to work around this problem?

Thank You!

 

[FengShui1998]

Twillard,

Try this web site:

http://www.15seconds.com/Issue/991021.htm

fengshui_1998

 

[TWillard]

Great article FengShui1998!! That was exactly what I was looking for. One of the links within the article is outdated. Therefore I could not download the webcnkit. However, I was able to obtain enough information to fix my immediated problem. Thanks Again.