ExcelBanter - how do i format

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - how do i format (https://www.excelbanter.com/excel-worksheet-functions/233137-how-do-i-format.html)

value of $21,480 and gain/loss of $4,080 to currency style format with
decimal poistions in excell

hi
how are these numbers displayed on the sheet?

regards
FSt1

"How do I format this in my excel wrk sht" wrote:

value of $21,480 and gain/loss of $4,080 to currency style format with
decimal poistions in excell

Hi,

Note sure what you mean by "decimal positions"

In general just click the $ button on the Home tab (2007) or the $ button on
the Formatting toolbar in 2003. Change the number of decimal places by
clicking the Increase or Decrease buttons also located on the Home tab or
Formatting toolbar.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire

"How do I format this in my excel wrk sht" wrote:

value of $21,480 and gain/loss of $4,080 to currency style format with
decimal poistions in excell