How do I make currency (dollar sign) fixed or floating?
D Dave Peterson Nov 2, 2006 #2 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.
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.
