Disable Excel's Auto Formatting
 

In Excel 2000, if you have a text of more than 15 digits
(eg: "12345678912345678912345"), excel automatically
changes this into exponential. If you have leading zeros
in a cell (eg: 0001), excel strips the leading zeroes.

Without changing the cell format, how do I disable excel's
automatic cell value formatting. Is there registry setting
that needs to be set?

Disable Excel's Auto Formatting
 

Formatting the cell as text would work, why isn't that acceptable? -
Pikus


---
Message posted from http://www.ExcelForum.com/

Disable Excel's Auto Formatting
 

More to the point numbers can only have up to 15 significant digits
in Excel. Please look up "Specification" in your Excel Help.

So "text" is your only choice. You can format the column as text
beforehand, or you can precede the value with a single quote
to force it to text.


"pikus " wrote in message ...
Formatting the cell as text would work, why isn't that acceptable? -
Pikus


---
Message posted from http://www.ExcelForum.com/

Disable Excel's Auto Formatting
 

Because if I'm sending an HTML file (and I specify this as
application/vnd.ms-excel)and IE opens it automatically in
Excel, I can't really specifiy in my HTML that this cell
value should only be formatted as text. It is of General
format by default.


-----Original Message-----
Formatting the cell as text would work, why isn't that
acceptable? -
Pikus


---
Message posted from http://www.ExcelForum.com/

.

Disable Excel's Auto Formatting
 

Then Dave's suggestion of a leading single quote should work. - Piku

--
Message posted from http://www.ExcelForum.com