Does anyone know how to custom format the correct display number using a number format or conditional format.
I have been using the accounting category with the $ sign to the far left.
If I type .2358 it displays $ 0.23 I can fix it by increase the decimal places however
if I type 2800.00 it displays $ 2,800.000
and 180.00 as $ 180,000
I have been using the accounting category with the $ sign to the far left.
If I type .2358 it displays $ 0.23 I can fix it by increase the decimal places however
if I type 2800.00 it displays $ 2,800.000
and 180.00 as $ 180,000