1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

Solved Excel Bank register balance display

Discussion in 'Business Applications' started by floydcojacket, Mar 2, 2019.

Thread Status:
Not open for further replies.
Advertisement
  1. floydcojacket

    floydcojacket Thread Starter

    Joined:
    Jul 4, 2008
    Messages:
    278
    How to have excel display a $0.00 balance as $ - instead of $0.00


    Tech Support Guy System Info Utility version 1.0.0.4
    OS Version: Microsoft Windows 10 Home, 64 bit
    Processor: Intel(R) Core(TM) i7-4790 CPU @ 3.60GHz, Intel64 Family 6 Model 60 Stepping 3
    Processor Count: 8
    RAM: 12225 Mb
    Graphics Card: NVIDIA GeForce GT 730, -2048 Mb
    Hard Drives: C: 910 GB (795 GB Free); D: 18 GB (2 GB Free);
    Motherboard: Hewlett-Packard, 2B2C
    Antivirus: Windows Defender, Disabled
     
  2. etaf

    etaf Moderator

    Joined:
    Oct 2, 2003
    Messages:
    65,252
    First Name:
    Wayne
    quite a few ways to do that
    you could use accounting format
    or set up your own custom format

    • Highlight the range you want to change the format
    • Right click > "Format Cells"
    • >"Custom"
    • >"Type" field copy _($* "-"??_);_($* "-"??_);_($* "-"??_);_(@_)
    thats show how to display + numbers , negative , zero text

    you will also see some of the custom formats
    like
    _(£* #,##0_);_(£* (#,##0);_(£* "-"_);_(@_)
     
  3. floydcojacket

    floydcojacket Thread Starter

    Joined:
    Jul 4, 2008
    Messages:
    278
    Thank you so much as your first suggestion did the trick. WOW, way past my excel knowledge.
     
  4. etaf

    etaf Moderator

    Joined:
    Oct 2, 2003
    Messages:
    65,252
    First Name:
    Wayne
    you are welcome
     
As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Loading...
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/1223845

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice