Solved

Excel 2003 (XLS) question regarding rounding up.

Posted on 2012-04-06
2
217 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

Back Up Your Microsoft Windows Server®

Back up all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Question has a verified solution.

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

This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
The viewer will learn how to  create a slide that will launch other presentations in Microsoft PowerPoint. In the finished slide, each item launches a new PowerPoint presentation and when each is finished it automatically comes back to this slide: …
Learn how to create and modify your own paragraph styles in Microsoft Word. This can be helpful when wanting to make consistently referenced styles throughout a document or template.

822 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