| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
To display number in text format in cells
I have a sequence of digits like
5026555306553 I entered in a cell and when the cursor left the cell it displays as 5.02656E+12 How do I set the cell or the whole spreadsheet to display as text rather than this format? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Custom number display format | Excel Worksheet Functions | |||
| FormatCellsNumberText is very tricky! | Excel Worksheet Functions | |||
| Format number to display % symbol smaller than onther text in cell | Excel Discussion (Misc queries) | |||
| Number format need to display 0001 etc | Excel Discussion (Misc queries) | |||
| Excel cells should take number format and/or optional text eg Dec. | Excel Discussion (Misc queries) | |||
Threaded Mode
