Results 1 to 4 of 4

Request Custom formating

Threaded View

  1. #1
    Registered User
    Join Date
    11-20-2008
    Location
    India
    Posts
    2

    Request Custom formating

    I am having a custom formatting expression in Excel 2003 which displays "-" if the cell value is 0.
    The expression I am using is the following.

    _(* #,##0_);_(* (#,##0);_(* "-"??_);_(@_)

    I need to change this for the following conditions
    If cell value >500 then should show blank and if cell value =0 then should display "-". I am new to excel custom formating.
    Appreciate the help from experts at the earliest for this.

    Thanking you in Advance,
    Raj
    Last edited by VBA Noob; 11-20-2008 at 03:27 AM. Reason: adding code tag not succeeded

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1