Simple (?) Formula Problem

  • Thread starter Thread starter Phil Hageman
  • Start date Start date
P

Phil Hageman

In cell O4, the formula =Customer!D10 brings in the data
in D10.

In cell O5, the formula =Customer!D11 does not show D11
data, but shows the formula itself.

How do I change the O5 formula to bring in data rather
than show the formula itself?

Thanks, Phil
 
Hi,

Check the number format of cell O5. It could be set as "Text".

--
Regards

Haldun Alay

To e-mail me, please replace AT and DOT in my e-mail address with the original signs.



"Phil Hageman" <[email protected]>, iletide sunu yazdi In cell O4, the formula =Customer!D10 brings in the data
in D10.

In cell O5, the formula =Customer!D11 does not show D11
data, but shows the formula itself.

How do I change the O5 formula to bring in data rather
than show the formula itself?

Thanks, Phil
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

In VBA how to select the right format for a range 7
Copying formulas in Columns and transpose to rows? 5
macro help please 2
Conditional Formatting 1
Problem with >= in function 4
sorting: cleared/null v/s "" 3
Subtraction Function using cells with other functions in them 2
Excel Excel Formula OFFSET maybe? 1

Back
Top