Named ranges

[AJThomas01]

Hi there,

I'm not sure why I'm getting this, but when I format my table, and try to insert a function and use table names, the formula is displayed and not the value. Why is this? before formating into a table, the result is displayed and not the formula ...

 

[Ruddles]

How have you formatted the cell containing the formula? General? Number? Text?

 

[AJThomas01]

as general

 

[Ruddles]

Okay, that's good. What do you mean by "formatting into a table"? Are you talking about an actual Excel table (Insert > Table)?

 

[AJThomas01]

yes ...