Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Working with formatted values
I am trying to reference formatted data (eg. 8.6) as opposed to the
unformatted data (8.5789....) in a cell in that is in another worksheet which is apart of the same workbook. The problem I am having is my calculation are using the unformatted data which skews my results. Simply put, I just want to "fix" the data that I see in the source worksheet for further calculations later! Please help!!! :) -- A squirrel trying to get a nut!!! |
#2
|
|||
|
|||
Then you must make the value the same as the format. For instance, if 8.6 is
in A1, you would have to put: =round(a1,1) (this rounds A1's value to 1 decimal place) followed by your current formula. ************ Anne Troy www.OfficeArticles.com "Phyzycal" wrote in message ... I am trying to reference formatted data (eg. 8.6) as opposed to the unformatted data (8.5789....) in a cell in that is in another worksheet which is apart of the same workbook. The problem I am having is my calculation are using the unformatted data which skews my results. Simply put, I just want to "fix" the data that I see in the source worksheet for further calculations later! Please help!!! :) -- A squirrel trying to get a nut!!! |
#3
|
|||
|
|||
Alternatively, you could check the Tools/Options/Calculation/Precision
as displayed checkbox. This will apply to the entire workbook, however. In article , "Anne Troy" wrote: Then you must make the value the same as the format. For instance, if 8.6 is in A1, you would have to put: =round(a1,1) (this rounds A1's value to 1 decimal place) followed by your current formula. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Why do old, unused values still show in my Pivot Page fields? | Excel Discussion (Misc queries) | |||
How do I summarize totals for a list of values in Excel? | Excel Worksheet Functions | |||
How To Use Cells Without Values in a Formula | Excel Worksheet Functions | |||
project values based on other values | Excel Discussion (Misc queries) | |||
Leading Zeros in Numeric Values | Excel Worksheet Functions |