Expiring Today—Celebrate National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Excel 2003 (XLS) question regarding rounding up.

Posted on 2012-04-06
2
Medium Priority
?
224 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 18

Accepted Solution

by:
xtermie earned 2000 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

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Question has a verified solution.

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

This article helps those who get the 0xc004d307 error when trying to rearm (reset the license) Office 2013 in a Virtual Desktop Infrastructure (VDI) and/or those trying to prep the master image for Microsoft Key Management (KMS) activation. (i.e.- C…
New style of hardware planning for Microsoft Exchange server.
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 simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…

730 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