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.
 
Back
Top