Entewring long numbers into Excel
 

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.

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.

Select the cell(s)
Choose FormatCells
On the Number tab, select the Number category
Click OK

Misha wrote:
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.


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html