Un-round a rounded number

[dgiannoccoli]

I am linking to a sheet with rounded numbers, however in my new worksheet I want my numbers to show un-rounded.

So if my # is 47,325 and it was rounded to 47,000, when I link to the new sheet I want it to be 47,325.

Any ideas?

Thanks

 

[Norie]

How is the rounding being done?

If the actual value in the other sheet has been rounded to 47,000 then I can see how you could get the 'unrounded' value.

If the rounding is just the result of formatting then just change the format in the destination.

 

[dgiannoccoli]

used the roundup formula

 

[Norie]

Well why not link to the cell with the value being rounded up instead of the cell with the ROUNDUP formula?

 

[dgiannoccoli]

The rounded # is in a summary worksheet. The rounded # is the sum of multiple un-rounded numbers from different worksheets. Instead of linking back to all those worksheets I would like to link to the summary page and get the un-rounded sum.

 

[Norie]

Like I said I don't think this is possible.

How is Excel supposed to work out the 'unrounded' figure?

 

[dgiannoccoli]

Thanks