If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Why does this fail? =TEXT(RC3,Number)&" / "&TEXT(R32C,Number)
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. |
#2
|
|||
|
|||
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. ... 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. |
#3
|
|||
|
|||
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 . RC3,Number wrote: 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. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Access2K append queries fail under XP Pro | [email protected] | Running & Setting Up Queries | 1 | May 25th, 2005 08:46 PM |
need to return Pass or Fail to text box or label | dtoney | New Users | 4 | February 8th, 2005 06:31 PM |
Queries fail for certain users on certain machines | Jeff Vandervoort | Running & Setting Up Queries | 0 | January 25th, 2005 12:37 AM |
pass fail | Tricia | New Users | 3 | January 20th, 2005 03:45 PM |
PASS or FAIL? | Param | Worksheet Functions | 5 | July 16th, 2004 10:55 AM |