View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default 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