View Single Post
  #1   Report Post  
Phyzycal
 
Posts: n/a
Default 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!!!