>Hi all,
>I have a report that in one of it's numeric fields i set its format to 999/999/999. but if my number be 87654 it show as / /87/654 . if i set format as 999,999,999 it show correctly as 87,654 !
>where i do wrong?
>Thanks for your help
You will have to cheat a little bit
? strtran(Transform(87654, '@R 999,999,999'), set('separator'), '/')
Gregory