Custom Label

How can I enter a formula in a cell, but have the cell display something completely different.

My particular formula happens to be:
"=(B5*D19*B7)-((B11*D19*B7)+B15+B16)".
However, I want the cell to display the word "Customer" and nothing else.

I just need the formula in that cell in order to for a data table to reference it.

Thanks,
Bryan

Originally Posted by Bryansb

How can I enter a formula in a cell, but have the cell display something completely different.

My particular formula happens to be:
"=(B5*D19*B7)-((B11*D19*B7)+B15+B16)".
However, I want the cell to display the word "Customer" and nothing else.

I just need the formula in that cell in order to for a data table to reference it.

Thanks,
Bryan

Cover the cell with a non-working Button named 'Customer'?
---

Originally Posted by Bryan Hessey

Cover the cell with a non-working Button named 'Customer'?
---

I've since figured out how to do it...
Format>Cell>Custom
Then I just typed "Customer" instead of using one of the preset custom settings.

But thanks for your help though, I appreciate it.
Sad as it sounds, it took me about a week to figure that out...
Bryan

Originally Posted by Bryansb

I've since figured out how to do it...
Format>Cell>Custom
Then I just typed "Customer" instead of using one of the preset custom settings.

But thanks for your help though, I appreciate it.
Sad as it sounds, it took me about a week to figure that out...
Bryan

At least you figured it out - and thanks for the response.
---