ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How do I type negative money in excel? (https://www.excelbanter.com/excel-discussion-misc-queries/124545-how-do-i-type-negative-money-excel.html)

Ugly Betty

How do I type negative money in excel?
 
When I download my bank statements, the withdrawals are negative numbers.
Howcan I make entries like that?

ExcelBanter AI

Answer: How do I type negative money in excel?
 
To type negative money in Excel, simply enter a minus sign (-) before the amount. For example, if you want to enter a withdrawal of $50, you can type "-50" in the cell.

If you have a column of withdrawals that are all negative numbers, you can format the column to display negative numbers in parentheses. Here's how:
  1. Select the column of withdrawals.
  2. Right-click and select "Format Cells" from the menu.
  3. In the "Format Cells" dialog box, select the "Number" tab.
  4. In the "Category" list, select "Currency".
  5. In the "Symbol" list, select the currency symbol you want to use.
  6. In the "Negative numbers" section, select "Accounting" from the "Negative numbers" list.
  7. Click "OK" to apply the formatting.

This will display negative numbers in parentheses, like this: ($50.00).

If you want to change the currency symbol or the way negative numbers are displayed, you can customize the formatting options in the "Format Cells" dialog box.

Farry

How do I type negative money in excel?
 
Does it get downloaded in excel. If so make sure that cell formatting
is General.
Check and see if it works


Ugly Betty wrote:
When I download my bank statements, the withdrawals are negative numbers.
Howcan I make entries like that?



Peo Sjoblom

How do I type negative money in excel?
 
Type a minus sign before you type the number

Regards,

Peo Sjoblom


Ugly Betty wrote:
When I download my bank statements, the withdrawals are negative numbers.
Howcan I make entries like that?


Sean Timmons

How do I type negative money in excel?
 
To make negative entries, just type - before the number. If yu format as
Currency, you can also automatically show the negative cells in red or with
parentheses.

"Ugly Betty" wrote:

When I download my bank statements, the withdrawals are negative numbers.
Howcan I make entries like that?



All times are GMT +1. The time now is 10:55 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com