excel number appearances
 

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

excel number appearances
 

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.


"longgone" wrote:

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