Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

Numbers - Is there a way to evaluate formula just once?

Hi, i've created some currency conversion formulas in numbers but i need them to be static after evaluation, in the spreadsheet i input the amount i payed for things and i want it to be converted to my local currency but only on the day of purchase, otherwise the amount wont be accurate.

MacBook Pro with Touch Bar

Posted on Sep 4, 2019 10:34 AM

Reply
Question marked as Best reply

Posted on Sep 4, 2019 12:21 PM

Hi dsuttonbetech,


I don't see a way of automating this but it is simple to do.

Copy the cell data, then Paste Formula Results back in the cell. You are done.


quinn

Similar questions

1 reply

Numbers - Is there a way to evaluate formula just once?

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple ID.