| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Numbers appear as ##### instead of the actual number, how to fix?
Some of my stydents have entered numbers into cells or done a summation of a
series of cells and they get ###### signs in place of the actual number...when mousing over the cell with the ###### a fly out appears with the actual number. How do we make the ###### signs appear as the actual number? |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Numbers appear as ##### instead of the actual number, how to fix?
Normally adjusting the column width should fix that.
ws65swc wrote: Some of my stydents have entered numbers into cells or done a summation of a series of cells and they get ###### signs in place of the actual number...when mousing over the cell with the ###### a fly out appears with the actual number. How do we make the ###### signs appear as the actual number? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Why are 1/2 my numbers imported as text and the rest as numbers? | Excel Discussion (Misc queries) | |||
| can I delete the 1st number from a string of numbers | Excel Discussion (Misc queries) | |||
| return largest number of a list of numbers in the same cell | Excel Worksheet Functions | |||
| How do I filter a number list by numbers to the right of the decim | Excel Worksheet Functions | |||
| Match Last Occurrence of two numbers and Count to Previous Occurence | Excel Worksheet Functions | |||
Linear Mode
