Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Dec 2001
    Posts
    174
    Thanks
    0
    Thanked 0 Times in 0 Posts

    currency format (excel2003)

    I need to create a special currency format " K$" so that K$30 will still be recognized as a number/currency so that conditional cell formating by value is still available.
    ie- cell contains K$30 --Conditional formating "less than 30" background color shall be red
    Many thanx
    Smbs

  2. #2
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: currency format (excel2003)

    If you apply a custom number format like this:
    K$ #,
    the cell will display 123,456 as
    K$ 123
    But excel will calculate using 123,456. Your CF needs to take that into account.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  3. #3
    2 Star Lounger
    Join Date
    Dec 2001
    Posts
    174
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: currency format (excel2003)

    Got it ---many thanx
    Smbs

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •