Hi,

I'm having an issue with the =TEXT(value,Format_text) function

How can I use a cell reference as the format_text part of the TEXT Function?

For example:
=text(5.555,"0.00")
returns 5.56

=TEXT(5.555,INDIRECT(A5))
where A5 = "0.00"
returns #REF



Here is the file:
Text(#,Indirect).xlsx

Thanks for your help.