Solved

Excel 2003 (XLS) question regarding rounding up.

Posted on 2012-04-06
2
219 Views
Last Modified: 2012-04-24
Hello,

I was recently asked a question about a scenario that I don't know the answer to:

A person has two Excel 2003 spreadsheets. One has columns containing "hours worked" in a 0.00 format. Apparently there are no formulas and each line has been entered manually. This person has copied and pasted a number of columns one at a time from this particular spreadsheet to another Excel 2003 spreadsheet. All of the information copied shows the correct information except for the "hours worked" column. For some reason anything 0.01 or higher was automatically rounded up to the next full number. So an entry of 3.40 hours pasted as 4.00 hours. The numeric format is the same, so it's rounding up to 4.00 and not 4.

I can only go by what this person is telling me, as they are not local to me. I don't have access to the actual spreadsheets. Is there a setting in Excel 2003 (or higher) that might cause numbers to be automatically rounded up to the next whole number when there are no formulas applied?

Thanks for any input!
0
Comment
Question by:Mandr1ch
2 Comments
 
LVL 18

Accepted Solution

by:
xtermie earned 500 total points
ID: 37817779
Hey there, try to check two things
(a) if you select the cell that should contain the 3.40 does the FORMULA BAR display 4 or 3.40
(b) check to see what is the format of the cell

A way to lose digits  is to have omitted double precision
Could you advise on (1) and (2)?

Thanks
0
 

Author Comment

by:Mandr1ch
ID: 37817883
Forwarded this info on to the person with access to the documents. I will report back between now and Monday with the results. Thank you for the suggestion!
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Since upgrading to Office 2013 or higher installing the Smart Indenter addin will fail. This article will explain how to install it so it will work regardless of the Office version installed.
In this article we discuss how to recover the missing Outlook 2011 for Mac data like Emails and Contacts manually.
This video shows where to find templates, what they are used for, and how to create and save a custom template using Microsoft Word.
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …

821 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question