ToText

[ituser2008]

I am trying to convert a number field to a string field but when I used the totext function, it returned 'comma' to the output. How can I elimiate the ',' from the output??

Any help will be greatly appreciated.

Plan_id with type= number (22,0)

left(totext({plan_ID}, 0), 5)

output

13,22

 

[AndyMc]

ituser2008,

try:

totext({plan_ID}, 0, "")

Andy

 

[dgillz]

So what is the desired output? 1322? 13? 13.22?

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"What version of URGENT!!! are you using?