formatting numbers in cells

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

Mary Jo

Hi. I tried to format a group of horizontal cells by
going to format celss, then entering the following:
number, 2 decimal places, $ sign and then (2,184.10). I
clicked on okay. What I ended up with was the correct
formatting in the last cell, and the rest of them have
#### in the cells. Can someone tell me why this happened
and how to correct it? Thanks!
 
one reason for #### is that the cell isn't wide enough for the format
specified. Try widening the columns.
 
Expand the column width for each of the cells that have the ##### in them


: Hi. I tried to format a group of horizontal cells by
: going to format celss, then entering the following:
: number, 2 decimal places, $ sign and then (2,184.10). I
: clicked on okay. What I ended up with was the correct
: formatting in the last cell, and the rest of them have
: #### in the cells. Can someone tell me why this happened
: and how to correct it? Thanks!
 
Do you try :

format > cell > number > currency > decimal place = 2 > symbol = $

it can directly add currency side before number.

HTH

norik
 
Back
Top