Why does this fail? =TEXT(RC3,Number)&" / "&TEXT(R32C,Number)

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I get the fatal #Name? error with this and none of the help suggestions makes
any difference. All I'm trying to do is use numbers to write a text
expression. Why aren't examples included with your help? I've been
using Maple, and their examples are very helpful.
 
Try this, I haven't used the R1C1 references,
=TEXT(A1,"0.0")&" / "&TEXT(A2,"0.0")
you can adjust "0.0" to display the number of decimals you need,
Regards,
Alan.
news:[email protected]...
 
Because "Number" is not a valid argument in the TEXT function.
Instead, use something like "$0.00" or "0%" or "-1234". I'm not
sure why you even need the TEXT function, because I was able to
make it work with just =RC3&" / "&R32C .
 
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

Convert Number to Text for Index/Match 1
text and numbers 16
Repeat text a number define of times 6
How to extract text from number/text cell 6
Count number of rows with specific text 2
Number to Text 3
Select 3/4 digit numbers from text 1
Count for text 4

Back
Top