Currency
 

How do I make currency (dollar sign) fixed or floating?

Currency
 

This will float the $ near the first digit:
$#,##0.00

This will right justify the number portion and left justify the $ portion:
$* #,##0.00

The asterisk (*) says to pad using the next character (a space in this example)
to fill the cell.



RHiggs wrote:

How do I make currency (dollar sign) fixed or floating?

--

Dave Peterson