accounting format

  1. T

    Simple Pivot Table Years (number format) in Filter shows as Accounting Format

    Hello. This is a weird event in my pivot table. I have a raw/flat file that has a column with years in it formatted as a number (2015, 2016, etc). In my pivot table filters and if used as column headers or values they show as accounting formatted ($2,017). I've done everything from...
  2. R

    Currency/Accounting dropdowns

    Is it possible to change these currency options? I use 2 or 3 currencies regularly and would like to have the other two be easily accessible along with USD. Thanks for your help!
  3. L

    Change currency format of all currency cells in a workbook based on a dropdown/input

    Hi All, I've been struggling with this for a while and it would be amazing if I could solve it! Word of warning, My VBA knowledge is limited :(. My Goal: To have a cell where you enter (or select from a dropdown) a currency (USD,EUR,GBP etc.) that then changes all currency cells in a workbook...
  4. C

    VBA to switch Currency Formats (USD, GBP, EUR, etc)

    My overall goal with the code below is to replace all $ formats in a workbook with £ or € as selected by the user. However the code seems to get stuck on the line " Application.ReplaceFormat.NumberFormat = ReplaceNew " which returns null. As far as I can tell, the only reason for this is...
  5. S

    Number Format Question

    Hi, I need help with formatting number in a cell. I want to format a cell with "accounting" with negative numbers showing in a red parenthesis, but it only shows with negative sign when I format it with "accounting". How can I customize the "accounting" format to show negative numbers in red...
  6. H

    Customizing the Accounting Formats dropdown list

    Hi friends! I'd like to know if there is anyway to customize the "Accounting Formats" dropdown list at the Home tab, Number section in the ribbon. Does any of you Excel Blackbelt Ninja know how to do that? Just for clarification, I don't need to create any custom format, what I need is to...
  7. A

    Accounting Software Excel Format

    Please let me know if excel can automatically perform debits and credits. For example: 1.After an invoice is made. Excel will automatically deduct the number of the items sold in the invoice in the stock sheet. 2.Since the invoice was not paid. Excel will add the due amount in the customer...
  8. B

    Blank cell which is not blank?

    When accounting software (in my experience) outputs an account in XL format, I find that the spaces are not necessarily spaces. It's easier to explain if I give you an example. Here is a small sample of the output. Columns A...
  9. T

    Custom Format - align currency symbols

    I am using the custom cell format to change the way large numbers are displayed but cannot find how to align the currency symbol similar to using the built-in "accounting format". I want to display "$97,234,567" (for example) as "$97.23 M" and align the subsequent cells with the currency symbol...
  10. H

    currency symbol not aligned

    Hi, I am new to the forum and also not very savvy with Excel. This may be an easy question but I just don't know how to solve it. Any help is appreciated! I use Excel 2008 on mac. 1. I am using accounting format for the price column of my spreadsheet. I like how the figure is indented away...

This Week's Hot Topics

  • separating multiple Proper names (uppercase letters) from a list
    I have a list of proper names that only has spaces between their first and last names. I need a formula that can separate these names into...
  • 'for' Loop
    Hello guys, I am trying to do something new. With the help of a VBA code, in every case, last 2 Values of last 2 cells of columns D-15 to D-28 to...
  • Open specific pdf in folder with vba
    Hi, Below is the code in use , unable to find rich icon to put code inside using a mobile. The code in use is shown below. Everything works as it...
  • What is wrong with this For Loop code?
    I am trying to loop through each cell in Column U from U4 to last row to check if the percentage in the cell is greater than -.050%. In a...
  • Data to match
    Hi there, I have created 2 worksheets with data. First is all materials used and second has the bottle type used for each of material. How can I...
  • Shifting Columns
    Hi Dear Community, I'm trying to find the best way to Shift (Cut - Paste) all the information below and to the right of the "Worker" cell in VBA...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back