Results 1 to 5 of 5

Accounting Format, Rounded to the Nearest 1000

Threaded View

  1. #1
    Registered User
    Join Date
    06-25-2011
    Location
    Chicago, IL
    MS-Off Ver
    MS 365 apps for business
    Posts
    63

    Accounting Format, Rounded to the Nearest 1000

    Hi,

    I have a budget spreadsheet where I would like to display values rounded to the nearest 1000, without changing the actaul value. I want to keep the accounting format with the $ sign and ( ) for negative numbers. An example $8,965 I want to display as $9,000. If it's negative $(8,965) then as $(9000). The value needs to stay as the 8965.

    Thanks for the help!
    Last edited by zpenacho; 02-19-2018 at 10:04 PM. Reason: marked as solved

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Display Nearest Rounded Sizes Calculated From Values In Textbox & Cells
    By swordswinger710 in forum Excel Programming / VBA / Macros
    Replies: 30
    Last Post: 04-12-2016, 02:57 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. [SOLVED] Round to Nearest 1000
    By djfatboyfats in forum Excel General
    Replies: 2
    Last Post: 09-03-2014, 11:11 AM
  4. Round to nearest 1000 VBA
    By WAW in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-24-2010, 07:17 AM
  5. Calculating parts costs rounded to the nearest $15 in Excell
    By Mmellex in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-19-2006, 02:00 AM
  6. [SOLVED] how do I convert numbers to the nearest 1000
    By Brian in forum Excel General
    Replies: 2
    Last Post: 02-07-2006, 08:45 PM
  7. rounding nearest 1000
    By SMILE in forum Excel General
    Replies: 2
    Last Post: 04-06-2005, 01:20 AM

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