View Single Post
  #2   Report Post  
Don Guillett
 
Posts: n/a
Default

Limit is 15 so you must precede with ' or format as text first

--
Don Guillett
SalesAid Software

"Misha" wrote in message
...
I am very new to Excel. When I enter a long number into a cell I get a
formula I do not understand. Even if I widen the column, the formula

stays.
and the number reappears only when I double-click on the cell, but then
reverts to the formula when I click off it. How do I get the number to
display all the time?
Thanks.