PDA

Click to See Complete Forum and Search --> : CR 11 Formatting a Formula Field?


Besoup
Mar 20th, 2006, 09:16 AM
Hey,
I got a formula field that I am using to display 2 numbers coming from 2 different database fields. The problem is, that CR is adding 2 decimal places and a comma for the thousands seperator. How can I remove this formatting in a formula field?

Thanks!

Besoup
Mar 20th, 2006, 11:03 AM
I have:

{Header.Header_Number} & "-" & {Header.Header_Draw_Number}


but it outputs 45,998.00-0.00

I need to remove the comma and decimal points fromt the display... anyone have an idea?