View Single Post
  #2   Report Post  
Richard Buttrey
 
Posts: n/a
Default Excel puts a 0 at the end of my number

On Fri, 4 Nov 2005 10:49:10 -0800, "Dan Connors"
wrote:

I am putting large number into a cell, why does Excel changing my last number
to a zero? Is there a way to leave it the way I want it?



By a large number, I guess you mean one containing 15 digits.

You need to format the cell as text. You won't of course be able to do
any arithmetic with it.

HTH

__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________