Numbers appear as ##### instead of the actual number, how to fix?

G

Guest

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?
 

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

numbers appear different after hitting enter 3
negative number format 1
Time to Number Conversion 2
Page number shows "#" instead of number 2
Determining How An Existing Cell Is Formatted ? 4
Text does not appear in cell, instead "#########..." 5
block of cells appear as single cell 2
how do I get rid of ###### that appear instead of text in excel? 2

Top