numbers format

[Mary Jo]

I formatted a group of cells, using currency,2 decimal
places, the $ sign. When I clicked okay only one cell
formatted; the rest have ##### in each cell. Can anyone
tell me what to do to correct it?

 

[Bernard V Liengme]

Hi MaryJo,
Your column is not wide enough.
1) Select column and use Format|Column and set a width, OR
2) Use the mouse to grab the column border (for example between B and C) and
drag to make column wider, OR
3) Double click on column border to get automatic fit to size for column
Best wishes
Bernard

 

[Mary Jo]

Thank you Bernard,
It worked

-----Original Message-----
Hi MaryJo,
Your column is not wide enough.
1) Select column and use Format|Column and set a width, OR
2) Use the mouse to grab the column border (for example between B and C) and
drag to make column wider, OR
3) Double click on column border to get automatic fit to size for column
Best wishes
Bernard






.

 

[JE McGimpsey]

See an answer to your post in another group.