![]() |
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:) |
All times are GMT +1. The time now is 06:48 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com