Formulas

Hi Jennifer,

Thank you for your question.

In order to link just a number but not the formula from another file, you must have the two files open first.

1) On file one, set up your formula by type in =
2) Use the mouse to click on the cell you need on File 2
3) Press Enter

You should see the number showing on File 1 but not linking the formula.

I hope this resolves your question. If it has, please mark this question as resolved.

If you require further assistance, please reply to this post. Or perhaps you have another X question?

Have a great day.

Regards,

Katie Woo
(Microsoft Office Specialist Trainer)