View Single Post
  #5   Report Post  
David McRitchie
 
Posts: n/a
Default

Hi Gord,
In other words
"Doesn't work as expected" <grin

Thanks for the explanation, of what the poster would have seen.

"Gord Dibben" <gorddibbATshawDOTca wrote ...
I believe OP was getting his 13 numbers formatted to Scientific Notation.

1.23457E+12 may look like a formula to some people.



"CyberTaz" wrote in message
I'm entering a 13 digit number into a cell and instead of displaying the
number typed excel converts the number into a formula. Is there a way of
turning this off so I get what I type? Thanks