formatting numbers in cells

[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!

 

[JE McGimpsey]

one reason for #### is that the cell isn't wide enough for the format
specified. Try widening the columns.

 

[Lady Layla]

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!

 

[norika]

Do you try :

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

it can directly add currency side before number.

HTH

norik