Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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:) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Formatting numbers | Excel Discussion (Misc queries) | |||
creating a custom list of numbers | Excel Worksheet Functions | |||
Formatting of numbers in a cell on another sheet | Excel Worksheet Functions | |||
conditional formatting | Excel Worksheet Functions | |||
make custom formatting permanent | Excel Worksheet Functions |