Paste Formula Result in Apple Numbers does not preserve values from random functions like RANDBETWEEN

Hi everyone,

I’ve encountered a frustrating limitation in Apple Numbers related to the Paste Formula Result feature and how it handles formulas that involve random number generation — specifically the RANDBETWEEN function.

When copying a cell that contains a formula using RANDBETWEEN, I expect Paste Formula Result (Edit → Paste Formula Result or ⌘⇧V) to paste the final static value — as it would in Excel's Paste Values.

However, Numbers recalculates the formula during the paste operation, which results in a new random value, not the original one I intended to preserve.

This makes it impossible to “freeze” the value generated by RANDBETWEEN, unless I manually type it in another cell, or go through indirect workarounds.

I know that we can fix by using other app.

If I paste the value to a plain text app (like Notes or TextEdit) first, then copy it again and paste it back into Numbers, it works. But this is tedious for large datasets.

Can anyone explain me more about this?

thanks before