You can make a difference in the Apple Support Community!

When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.

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 Top-ranking 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 Account.