Convert Number to Text 4

[rewob65]

Can I convert a number to text I use crystal 8.5.


Thanks

 

[ANDREWeire]

Can you not just use ToNumber({fieldname}) ???

 

[rewob65]

I am converting to text not to a number, I thought it may be tostring

 

[GJParker]

If you want to convert 541 to '541' then you can use ToText() or Cstr(), but if you wish to convert 541 to Five Hundred and Forty One then that's a completely different story. Which do you want ?



Gary Parker
MIS Data Analyst
Manchester, England

 

[rewob65]

The first. Thanks Gary, Your help today and yesterday has been really good. Out of interest is there any easy way to do the second example.

 

[GJParker]

The ToWords() function appeared in Version 8.5

ToWords(541,0)

HTH

Gary Parker
MIS Data Analyst
Manchester, England

 

[bejay1066]

Hi there, I am new to Crystal Reports and would like to know if it is possible to enter a formula where if a date is blank it can be replaced with the text "tba".

Many thanks
Bejay 1066

 

[bdreed35]

Try this:

if isnull({table.date}) then
"tba"
else
{table.date}

~Brian

 

[lbass]

Brian's solution would work if the date was a string. Otherwise, you could change it to:

if isnull({table.date}) then
"tba"
else
totext({table.date},"MM/dd/yyyy") //format as you wish

-LB

 

[JanetStackpole]

I am new to Crystal Reports (from Oracle Reports). I am attempting to pad a string. I have a dollar amount e.g. 1123.44 and need to pad it to 0000123.44. In Oracle this is easy. Is there Crystal function that will do this? Also, is there a trick to converting a number to text? When I use ToText(), I get 1,234.44. I don't want the comma.

 

[lbass]

With totext(), you can add two arguments, one for the number of decimals, and one to remove the dividing comma, by using:

totext({table.number},0,"")

To pad a number, you could also use the following:

totext({Table.number},"0000000.00")
//adding the number of places you want to the left or right of the
//decimal by adding additional zeros

-LB