Results 1 to 6 of 6

Format a cell that contains a 0 or a number that would round to 0 to apply a dash (-)

Threaded View

  1. #1
    Forum Contributor
    Join Date
    09-11-2014
    Location
    Eugene, Oregon
    MS-Off Ver
    MS EXCEL 2010
    Posts
    210

    Format a cell that contains a 0 or a number that would round to 0 to apply a dash (-)

    I want to format a cell or an entire column to have a dash in it when the cell contains a zero how ever I want it to apply the dash (-) when it rounds because I am not showing decimals. current if I put 0.05 in a cell it rounds it down to zero and in that cell it shows "0" and if I put a -0.05 in that cell it appears as a negative zero like so .(0) I have attached a couple of screen shots the one on the right is what it looks like when a number like 0.05 is entered and the one on the left is what I would like it to look like if I entered that same number in. I am think custom formatting would work which is what I currently use and it works so long as the amount I put in is .50 or larger or -.50 or smaller.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Number Format from Round Function within Concatenate
    By zeze in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 07-23-2020, 03:41 AM
  2. [SOLVED] Round Number Down by Decimal Places Using Format
    By jaclrsen in forum Excel General
    Replies: 8
    Last Post: 10-19-2012, 06:02 AM
  3. Replies: 11
    Last Post: 08-16-2012, 09:49 AM
  4. [SOLVED] How to format a cell to reflect a NIC's MAC Address ? (put in dash
    By jfen in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-17-2006, 04:40 PM
  5. Can I format a cell to round a number by 50 basis points (0.5)?
    By daveb in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-18-2005, 09:05 PM

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