LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Excel should calculate and display numbers properly, but doesn't.

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Formula Help - Can't get excel to calculate properly it''''''''sh hardy Excel Discussion (Misc queries) 1 February 10th 10 02:32 PM
Analysis ToolPak won't display properly in Excel 2007 Mantithesis Excel Discussion (Misc queries) 11 October 4th 08 12:48 AM
The formula does not calculate properly... Help me if you could.. xokaido Excel Worksheet Functions 4 July 30th 07 04:35 PM
Excel should calculate exponentials properly (right to left) expatrie Excel Worksheet Functions 5 April 26th 06 08:34 AM
How to calculate/properly display significant figures ending in 0 A Zaffiro Excel Worksheet Functions 5 June 28th 05 08:36 PM


All times are GMT +1. The time now is 05:42 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"