numbers format

  • Thread starter Thread starter Mary Jo
  • Start date Start date
M

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?
 
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
 
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






.
Click to expand...
 
Back
Top