Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I don't know much about Excel, but I'd like to program the cells for
accounting. How do I do this? |
#2
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I suggest you purchase Excel for Dummies to get started.
best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Bob Mulligan" <Bob wrote in message ... I don't know much about Excel, but I'd like to program the cells for accounting. How do I do this? |
#3
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
You cannot format cells to do math calculations.
You must enter formulas which reference other cells. A1 contains 123 A2 contains 456 In A3 enter =A1+A2 to get the sum of A1 and A2. There are many good Accounting Templates available at the MS Template Gallery. http://office.microsoft.com/en-us/te...377141033.aspx Browse through the Business and Personal sites. You will get a good idea of layout. Gord Dibben MS Excel MVP On Mon, 1 May 2006 11:25:01 -0700, Bob Mulligan <Bob wrote: I don't know much about Excel, but I'd like to program the cells for accounting. How do I do this? |
#4
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Bob
I would also suggest you have a look at a few on-line tutorials. Some tutorial sites for basics of Excel........ http://www.usd.edu/trio/tut/excel/index.html http://www.baycongroup.com/el0.htm http://office.microsoft.com/en-us/tr...831141033.aspx Gord On Mon, 01 May 2006 11:41:08 -0700, Gord Dibben <gorddibbATshawDOTca wrote: You cannot format cells to do math calculations. You must enter formulas which reference other cells. A1 contains 123 A2 contains 456 In A3 enter =A1+A2 to get the sum of A1 and A2. There are many good Accounting Templates available at the MS Template Gallery. http://office.microsoft.com/en-us/te...377141033.aspx Browse through the Business and Personal sites. You will get a good idea of layout. Gord Dibben MS Excel MVP On Mon, 1 May 2006 11:25:01 -0700, Bob Mulligan <Bob wrote: I don't know much about Excel, but I'd like to program the cells for accounting. How do I do this? Gord Dibben MS Excel MVP |
#5
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Someone will be along soon i am sure but I think you will need to be more
specific "but I'd like to program the cells for accounting." this is too general a statement. You might want to try in the meantime a google search for some basic stuff. "Bob Mulligan" <Bob wrote in message ... I don't know much about Excel, but I'd like to program the cells for accounting. How do I do this? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
checking that cells have a value before the workbook will close | Excel Worksheet Functions | |||
changing the way Excel displays selected cells | Excel Discussion (Misc queries) | |||
Hyperlink in Excel opens the right program, but can't read file. | Excel Discussion (Misc queries) | |||
I get a program error when I download an excel template | Excel Discussion (Misc queries) | |||
How to make empty cells as zero in excel add-ins for SQL Server an | Excel Worksheet Functions |