That worked except when I go over $9,999.99 it throw the right-sided 9 past
cell line on right.
IOW- the $ does not float to the left,
and the "," is not showing/printing.. Ex: $9999.99 (no biggy).

I don't mean to be "picky", I'm trying to learn how to format.
Should I just play with it(format/formula) or is there an easier way?

Thanks,
L.


"JE McGimpsey" wrote in message
...
Try Format/Cells/Number/Custom

"Total:"* $#,##0.00



In article ,
"L/P" wrote:

problem.
I tried to change General with Currency to get proper format and it
won't
take, unless there is something I'm missing.

suggestions please..
L.