excel number appearances

  • Thread starter Thread starter longgone
  • Start date Start date
L

longgone

some numbers in excel speadsheet appear like ####### How do I get rid of
them/fix them to show a currency amount
 
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.
 
You must log in or register to reply here.

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

Convert number to text as displayed 3
numbers and macros 4
Excel Sum numbers in cells that also contain text 34
Function in Excel to count and list number of entries of text valuesin a row. 2
IF formula for currency or Macro help. 0
Excel - How do I get Excel to spell out a current amount? 1
Decimal point will not hold 2 places in Excel 2003 3
How do I get data from a cell on another worksheet? 3

Back
Top