Copy formula as text

99% chance this is one of data format.

Numbers doesn't have any problem referencing cells across sheets within the same document.

If you want to copy a specific cell value rather than the underlying formula, then use Edit -> Copy followed by Edit -> Paste Formula Results

However, bear in mind that if you copy incompatible data types you might not get what you expect. This is also true of date fields where the field may display 'Jan 2025', but the underlying cell value is "January 4th 2025 12:34:56pm", which can break comparison fields when you think you're just comparing, say, the MONTH() of a date rather than the specific moment in time.

I'm further sure this is related to the problem because of your statements:

> When I refer to cell B235 which has a formula, it returns $0.00

This implies that B235 has a currency value

> however if I go back to cell B235 and manually type in Jan 2035

Now you're saying B235 should have a date value.

Which is it? B235 cannot be both a currency and a date value at the same time.

What value is in that cell. What value do you _expect_ to be in that cell?

hawkeyess75 wrote:

Excel doesn't have this problem.

From your description, since you haven't provided screenshots, I'm guessing your document is organized in a very "Excel-like" way.

If you haven't done so already you might want to have a look at the templates at File > New in your menu to understand good design for Numbers documents.

I don't really follow what you are trying to do but perhaps you could make use of copy via command-c followed in the target cell by Edit > Paste Formula Results.

SG