Disable Excel's Auto Formatting

  • Thread starter Thread starter Zleeperx
  • Start date Start date
Z

Zleeperx

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?
 
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.
 
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.
 
Back
Top