Entewring long numbers into Excel

M

Misha

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.
 
D

Debra Dalgleish

Select the cell(s)
Choose Format>Cells
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.
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Autonumber field in Excel that behaves the same as Access 0
Excel does not accept text format! 0
Paragraph numbering in Word 1
Finding the proper style field and the numbered paragraph value within the style 0
Merging from an Excel file with graphics 1
Copy addition formula of non-consecutive horizontal cells 2
How can the font and size of (all) citation numbers be altered? 1
Delete a formula but leave the data. 2

Top