+ Reply to Thread
Results 1 to 2 of 2

custom text in accounting cell

  1. #1
    Registered User
    Join Date
    03-29-2017
    Location
    Melbourne, Australia
    MS-Off Ver
    2010/2013
    Posts
    1

    custom text in accounting cell

    Hi there,
    i'm new here and didn't find anything like the problem in search.
    I am trying to get "AUD" to appear in a cell that is a =SUM

    "AUD "_-$* #,##0.00_-;-$* #,##0.00_-;_-$* "-"??_-;_-@_-

    [A1] 500 AUD $500.00
    [A2] 1000 AUD $1000.00
    [A3] =SUM(A1-B1)
    Result of [A3] -$500.00 i would like it to read AUD-$500.00 or -AUD$500.00

    Thanks in anticipation.
    Neil

  2. #2
    Valued Forum Contributor spitfireblue's Avatar
    Join Date
    01-29-2015
    Location
    Adelaide, Australia
    MS-Off Ver
    2007,2010,2016
    Posts
    610

    Re: custom text in accounting cell

    Try this:

    "AUD "_-$* #,##0.00_-;"AUD "-$* #,##0.00_-;"AUD "_-$* "-"??_-;_-@_-
    Regards,
    Stephen

    If you feel someone has helped you please thank them and click on the star on their post to add reputation.
    Please ensure that you use code tags where relevant, and mark solved threads as solved.
    Most of all please be respectful and understanding of others.

+ 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] Custom cell format - text with text
    By Mechjo16 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-31-2017, 05:02 PM
  2. How to load value from cell in accounting format and save in accounting format back
    By lazyserv in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-27-2015, 01:21 PM
  3. Replies: 2
    Last Post: 05-24-2013, 10:52 AM
  4. Accounting zero using custom format option
    By Jadams215 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-23-2013, 10:33 PM
  5. Replies: 2
    Last Post: 07-13-2012, 03:40 AM
  6. [SOLVED] Custom number format - Accounting
    By jrpeckham@gmail.com in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 10-11-2005, 02:05 PM
  7. [SOLVED] custom list with accounting format
    By TexMas in forum Excel General
    Replies: 0
    Last Post: 04-07-2005, 04:06 PM

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