After pasting the value using pastespecialvalues, Check both cell formats.

Remember to Click Yes, if this post helps!

--------------------
(Ms-Exl-Learner)
--------------------


"swiftgirl" wrote:

I recorded temperatures every 15 minutes for four months, and I need to use
the minimum daily temperatures for statistical calculations. I used the
Subtotals tool to find the min value for each day, and seperate the data into
layers.

However, now that I have the list of data I need, I can't figure out how to
use it. If I try to copy and past just the min values to another page, the
numbers change, even if I use "paste special", "values".

Can anybody help me please? Thanks