LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
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:)
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Formatting numbers Kathrine Excel Discussion (Misc queries) 1 November 24th 06 08:57 AM
creating a custom list of numbers Louise Excel Worksheet Functions 5 November 22nd 06 07:58 PM
Formatting of numbers in a cell on another sheet Slashman Excel Worksheet Functions 4 October 5th 06 09:21 PM
conditional formatting Lofty Excel Worksheet Functions 7 July 10th 06 09:06 PM
make custom formatting permanent simha Excel Worksheet Functions 1 November 15th 05 11:29 PM


All times are GMT +1. The time now is 01:17 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"