Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Create a credit (negative) column in Excel?
I am creating a spreadsheet with debit and credit columns. How do I format
the Credit column so all entries automatically post as a credit? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Create a credit (negative) column in Excel?
Credits are generally positive values.
Don't enter numbers with a negative value in the credit column. Enter those in your debit column. Or am I missing some detail? If you wanted negative values to show as positive, in a helper column enter =ABS(cellref) Gord Dibben MS Excel MVP On Thu, 5 Jul 2007 13:42:03 -0700, AvonSue wrote: I am creating a spreadsheet with debit and credit columns. How do I format the Credit column so all entries automatically post as a credit? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Create a credit (negative) column in Excel?
Hi Gordon,
Thanks for your speedy response! You have answered my question. FYI - in accounting, Assets and Expenses are Debit Accounts and Liabilities and Equity are Credit Accounts. This is necessary in order for your Trial Balance to zero-out so you can do financial statements and income statements. "Gord Dibben" wrote: Credits are generally positive values. Don't enter numbers with a negative value in the credit column. Enter those in your debit column. Or am I missing some detail? If you wanted negative values to show as positive, in a helper column enter =ABS(cellref) Gord Dibben MS Excel MVP On Thu, 5 Jul 2007 13:42:03 -0700, AvonSue wrote: I am creating a spreadsheet with debit and credit columns. How do I format the Credit column so all entries automatically post as a credit? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Create a credit (negative) column in Excel?
Thu, 05 Jul 2007 14:17:39 -0700 from <Gord Dibben
<gorddibbATshawDOTca: Credits are generally positive values. Don't enter numbers with a negative value in the credit column. Enter those in your debit column. Or am I missing some detail? Credits *and* debits are generally positive. In proper accounting books (using the double-entry method, which it sounds like the OP does), total credits must equal total debits. The OP should have positive credits and positive debits, and strike a balance by sum(debits) - sum(credits) for an asset or expense account, sum(credits) - sum(debits) for a liability or equity or revenue account. -- Stan Brown, Oak Road Systems, Tompkins County, New York, USA http://OakRoadSystems.com/ |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Create a credit (negative) column in Excel?
Shows how little I know about bookkeeping<g
My rudimentary style is a column of "ins" and a column of "outs" with the difference being what I still have in my pocket or owe to my creditors. Gord On Thu, 5 Jul 2007 19:23:12 -0400, Stan Brown wrote: Thu, 05 Jul 2007 14:17:39 -0700 from <Gord Dibben <gorddibbATshawDOTca: Credits are generally positive values. Don't enter numbers with a negative value in the credit column. Enter those in your debit column. Or am I missing some detail? Credits *and* debits are generally positive. In proper accounting books (using the double-entry method, which it sounds like the OP does), total credits must equal total debits. The OP should have positive credits and positive debits, and strike a balance by sum(debits) - sum(credits) for an asset or expense account, sum(credits) - sum(debits) for a liability or equity or revenue account. |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Create a credit (negative) column in Excel?
I need to convert my spreadsheet credit column. The numbers now show as red and I need them to show as a negative number instead.
On Thursday, July 05, 2007 4:42 PM AvonSu wrote: I am creating a spreadsheet with debit and credit columns. How do I format the Credit column so all entries automatically post as a credit? On Thursday, July 05, 2007 5:17 PM Gord Dibben wrote: Credits are generally positive values. Don't enter numbers with a negative value in the credit column. Enter those in your debit column. Or am I missing some detail? If you wanted negative values to show as positive, in a helper column enter =ABS(cellref) Gord Dibben MS Excel MVP On Thu, 5 Jul 2007 13:42:03 -0700, AvonSue wrote: On Thursday, July 05, 2007 6:58 PM AvonSu wrote: Hi Gordon, Thanks for your speedy response! You have answered my question. FYI - in accounting, Assets and Expenses are Debit Accounts and Liabilities and Equity are Credit Accounts. This is necessary in order for your Trial Balance to zero-out so you can do financial statements and income statements. "Gord Dibben" wrote: On Thursday, July 05, 2007 7:23 PM Stan Brown wrote: Thu, 05 Jul 2007 14:17:39 -0700 from <Gord Dibben <gorddibbATshawDOTca: Credits *and* debits are generally positive. In proper accounting books (using the double-entry method, which it sounds like the OP does), total credits must equal total debits. The OP should have positive credits and positive debits, and strike a balance by sum(debits) - sum(credits) for an asset or expense account, sum(credits) - sum(debits) for a liability or equity or revenue account. -- Stan Brown, Oak Road Systems, Tompkins County, New York, USA http://OakRoadSystems.com/ On Thursday, July 05, 2007 8:24 PM Gord Dibben wrote: Shows how little I know about bookkeeping<g My rudimentary style is a column of "ins" and a column of "outs" with the difference being what I still have in my pocket or owe to my creditors. Gord On Thu, 5 Jul 2007 19:23:12 -0400, Stan Brown wrote: |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Create a credit (negative) column in Excel?
Assuming the numbers are red because they are negative..........
You don't need to convert the numbers. Simply re-format with minus sign rather than red. FormatCellsNumberNumber........you choose from the selection. 2007 would be FormatFormat CellsNumberNumber Gord Dibben MS Excel MVP On Wed, 30 Mar 2011 18:43:50 GMT, Jen Moskaluk wrote: I need to convert my spreadsheet credit column. The numbers now show as red and I need them to show as a negative number instead. On Thursday, July 05, 2007 4:42 PM AvonSu wrote: I am creating a spreadsheet with debit and credit columns. How do I format the Credit column so all entries automatically post as a credit? On Thursday, July 05, 2007 5:17 PM Gord Dibben wrote: Credits are generally positive values. Don't enter numbers with a negative value in the credit column. Enter those in your debit column. Or am I missing some detail? If you wanted negative values to show as positive, in a helper column enter =ABS(cellref) Gord Dibben MS Excel MVP On Thu, 5 Jul 2007 13:42:03 -0700, AvonSue wrote: On Thursday, July 05, 2007 6:58 PM AvonSu wrote: Hi Gordon, Thanks for your speedy response! You have answered my question. FYI - in accounting, Assets and Expenses are Debit Accounts and Liabilities and Equity are Credit Accounts. This is necessary in order for your Trial Balance to zero-out so you can do financial statements and income statements. "Gord Dibben" wrote: On Thursday, July 05, 2007 7:23 PM Stan Brown wrote: Thu, 05 Jul 2007 14:17:39 -0700 from <Gord Dibben <gorddibbATshawDOTca: Credits *and* debits are generally positive. In proper accounting books (using the double-entry method, which it sounds like the OP does), total credits must equal total debits. The OP should have positive credits and positive debits, and strike a balance by sum(debits) - sum(credits) for an asset or expense account, sum(credits) - sum(debits) for a liability or equity or revenue account. -- Stan Brown, Oak Road Systems, Tompkins County, New York, USA http://OakRoadSystems.com/ On Thursday, July 05, 2007 8:24 PM Gord Dibben wrote: Shows how little I know about bookkeeping<g My rudimentary style is a column of "ins" and a column of "outs" with the difference being what I still have in my pocket or owe to my creditors. Gord On Thu, 5 Jul 2007 19:23:12 -0400, Stan Brown wrote: |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Enter credit (negative number) in sales template | Excel Discussion (Misc queries) | |||
how to enter negative amounts in the unit price column of excel | Excel Worksheet Functions | |||
Convert a column of numbers from positive to negative in Excel | Excel Discussion (Misc queries) | |||
create a formula in excel to prevnt negative | Excel Worksheet Functions | |||
How do I make all numbers in a column negative in excel 2000? | Excel Discussion (Misc queries) |