Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Bentley College switched to Office 2003 this year, and it is good for the
most part. However, there are weird problems I've never experienced with Excel before. When using "Accounting" for a cell format type, the dollar signs do not all line up on the left. I have made sure that ALL cells in the column are using the same formatting. On another worksheet, I am calculating ratios from financial statements. All I'm producing are 3 digit numbers, and the spacing is off. There is the number 3.87 in one cell and 3.07 in the cell below it, and the 3.07 is further to the left than 3.87. I have tried tabs, choosing different alignment types, but they all produce the same result. My roommate has noticed the same problems with his Excel as well. Pretty surprising for a product that has been in existence as long as Excel. On a separate issue, I have a column of numbers in a financial statement and it won't let me sum the cells. I get a "#VALUE!" error, but I have verified all the cells simply contain numbers and I'm asking nothing more than to add. I had to manually select a cell and add it to the next, which did work - something I would think proves that the cells contained valid and workable data. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Formula Help - Can't get excel to calculate properly | Excel Discussion (Misc queries) | |||
Analysis ToolPak won't display properly in Excel 2007 | Excel Discussion (Misc queries) | |||
The formula does not calculate properly... Help me if you could.. | Excel Worksheet Functions | |||
Excel should calculate exponentials properly (right to left) | Excel Worksheet Functions | |||
How to calculate/properly display significant figures ending in 0 | Excel Worksheet Functions |