| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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. |
|
#2
|
|||
|
|||
|
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. |
|
#3
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how write excel formula numbers in column => &=< between 20-40 | New Users to Excel | |||
| My formulas can't 'see' numbers imported from Access in Excel, even when the format is the same. | Excel Discussion (Misc queries) | |||
| BRACKETED NEGATIVE NUMBERS IN EXCEL | New Users to Excel | |||
| how do i set up to auto detect duplicated numbers in an excel fiel | Excel Discussion (Misc queries) | |||
| How do i increase the size of numbers in a text in Excel. | Excel Worksheet Functions | |||
Linear Mode
