Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
=TEXT(RC3,Number)& / &TEXT(R32C,Number
 
Posts: n/a
Default 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   Report Post  
Alan
 
Posts: n/a
Default

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   Report Post  
garfield-n-odie
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Links to 2nd closed worksheet fail when using offset function ?? Jordan795 Excel Worksheet Functions 1 June 21st 05 01:43 AM
Synchronization between Excel and Windows Sharepoint Services FAIL Rudy Tedaldi Excel Discussion (Misc queries) 1 March 16th 05 03:23 PM
&Text &Link 2 Dec places mate Excel Worksheet Functions 2 March 7th 05 11:58 AM
pass fail Tricia New Users to Excel 3 January 20th 05 03:45 PM


All times are GMT +1. The time now is 07:06 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"