Results 1 to 4 of 4

Request Custom formating

Threaded View

raj1234 Request Custom formating 11-20-2008, 02:07 AM
dominicb Good morning raj1234 ... 11-20-2008, 05:43 AM
raj1234 This forum look amazing and... 11-20-2008, 06:26 AM
dominicb Hi raj1234 Hmmm, as I... 11-20-2008, 11:07 AM
  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