+ Reply to Thread
Results 1 to 3 of 3

0s as dashes but more complicated

  1. #1
    Registered User
    Join Date
    08-26-2013
    Location
    New York City
    MS-Off Ver
    Excel 2011 (Mac)
    Posts
    1

    0s as dashes but more complicated

    Hi there, I'm a total novice when it comes to Excel and I'm having a little bit of trouble getting this formula right. Any help would be greatly appreciated!

    I'm making a jewelry line spreadsheet so cells that are meant for weight calculations, I would like to appear with a "g" for grams (for example "1.29 g"
    At the same time, if there is no weight and the cell is equal to 0, I would like for it to appear as a "-"

    I was able to achieve both formulas separately, but when I try to combine them I get an error. Does anyone know what the correct formula would be to achieve this?

    Thank you in advance!

  2. #2
    Forum Contributor
    Join Date
    06-26-2013
    Location
    LAX
    MS-Off Ver
    Excel 2007,Excel 2010
    Posts
    363

    Re: 0s as dashes but more complicated

    Welcome to the forum...

    What formula you use now?

  3. #3
    Forum Expert Ace_XL's Avatar
    Join Date
    06-04-2012
    Location
    UAE
    MS-Off Ver
    2016
    Posts
    6,074

    Re: 0s as dashes but more complicated

    Use this custom cell format

    #.##"g";;-
    Life's a spreadsheet, Excel!
    Say thanks, Click *

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Getting rid of some dashes
    By Ryanreid in forum Excel General
    Replies: 4
    Last Post: 08-21-2012, 12:21 PM
  2. dashes before and after letters
    By sheil in forum Excel General
    Replies: 2
    Last Post: 04-17-2010, 03:25 AM
  3. Replies: 1
    Last Post: 05-14-2008, 07:55 PM
  4. Stripping the dashes
    By digital21st in forum Excel General
    Replies: 4
    Last Post: 05-23-2006, 10:50 AM
  5. using dashes and the arrow key
    By cyndi in forum Excel General
    Replies: 1
    Last Post: 02-02-2005, 06:06 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