Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Displaying a double quote (")

Status
Not open for further replies.

CBMC

Programmer
Nov 22, 2001
13
CA
How do I use the Join function to display a double quote in CR8?

I need to display something like the following:

02'30"

I am currently using:

Join([ToText(num1, "00"), "'", ToText(num2, "00"), """]).

Of course it is not working, so any help would be much appreciated! Thanks
 
I am not sure why you are using Join. You can write the formula like:

Formula = ToText(Num1,"##") + Chr(39) + ToText(Num2,"##") + Chr(34)

I believe the the argument to the Join function has to be a String array containing substrings to be joined.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top