excel number appearances

L

longgone

some numbers in excel speadsheet appear like ####### How do I get rid of
them/fix them to show a currency amount
 
M

Mike H

Hi,

Maybe you need to widen the column a bit.

hover the cursor over column letter and slowly move to the right until the
cursor changes shape then hold down the left mouse button and drag.

--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.
 

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

Excel Sum numbers in cells that also contain text 34
What formula do I use for copying cell information between workboo 2
Providing a reference to another cell in a different workbook 2
Convert number to text as displayed 3
Count with multiple criterias 8
Finding Zeros 2
How do I print my spreadsheet to show the formulas of a cell? 3
If cell contains a value, multiply... 3

Top