![]() |
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? |
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:
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. |
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? |
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? |
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 01:10 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com