View Single Post
  #1   Report Post  
driller2 driller2 is offline
Junior Member
 
Posts: 27
Cool 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:)