Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Links to 2nd closed worksheet fail when using offset function ?? | Excel Worksheet Functions | |||
Synchronization between Excel and Windows Sharepoint Services FAIL | Excel Discussion (Misc queries) | |||
&Text &Link 2 Dec places | Excel Worksheet Functions | |||
pass fail | New Users to Excel |