custom formatting numbers
I am not good in custom formatting cell values..I need to populate a cell format in a large spreadsheet..
Format cell No.1 for quantities : data value entry is manual : decimals up to max.
Value = 1.250610 ---- I need to show it as "1.25061"
Value = 31.00 ----- I need to show it as "31"
Value = -1.250 ----- I need to show it as "(1.25)" in red font.
Value = -31.00 ----- I need to show it as "(31)" in red font.
Value = 0 ------ I need to show it as "-" to be aligned in the middle
all value : right side aligned
Format cell No.2 for money : data value entry is manual or by formula.
Currency Value = 1.250610 ---- I need to show it as "$ 1.25061"
Currency Value = 31 ----- I need to show it as "$ 31.00"
Currency Value = -1.250 ----- I need to show it as "($ 1.250)" in red font.
Currency Value = -31 ----- I need to show it as "($ 31.00)" in red font.
Currency Value = 0 ------ I need to show it as "-" to be aligned in the middle
all value : right side aligned
Dollar $ : left side aligned
thanks for any help..
rome lsb:)
|