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.
Why using Indirect there?
Try just
=text(5.555,A5)
Hi ninmjj,
Welcome to forum.
As mention by Jonmo1, you can use =text(5.555,A5), but your A5 = '0.00 NOT "0.00"
If you wish to use indirect.
Your A5 = '0.00 NOT "0.00",
=TEXT(5.555,INDIRECT("A5"))
-If the problem is solved, please mark your thread as Solved: Click Thread Tools above your first post, select "Mark your thread as Solved".
-Always upload a workbook before start your question
To attach a file, push the button with the paperclip (or scroll down to the Manage Attachments button), browse to the required file, and then push the Upload button.
+++ If my answer(s) helped you, please add me reputation by click on * +++
So Simple. Thanks. It worked perfectly.
Is great that your problem solved. :D
+++ If the problem is solved, please mark your thread as Solved: Click Thread Tools above your first post, select "Mark your thread as Solved". +++
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks