ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   custom formatting numbers (https://www.excelbanter.com/excel-worksheet-functions/122871-custom-formatting-numbers.html)

driller2

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