Solved

Excel 2003 (XLS) question regarding rounding up.

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

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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Problem: You created a new custom form in Outlook for your contacts (added fields, deleted fields, changed the layout of fields, whatever) and made it the default form for contacts. The good news is that all new contacts will utilize the new form. T…
Entering a date in Microsoft Access can be tricky. A typo can cause month and day to be shuffled, entering the day only causes an error, as does entering, say, day 31 in June. This article shows how an inputmask supported by code can help the user a…
This video shows and describes the main difference between both orientations in Microsoft Word. Viewers will understand when to use each orientation and how to get the most out of them.
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 …

911 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

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now