Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 226
  • Last Modified:

Excel 2003 (XLS) question regarding rounding up.

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
Mandr1ch
Asked:
Mandr1ch
1 Solution
 
xtermieCommented:
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
 
Mandr1chAuthor Commented:
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

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now