Number Format in a Calculation

[HonkyCat]

Hello,

I have a calculation field that is going to be used in a "send mail" script. One of the fields that needs to show up in the calculation is a number field that contains a report number (example; 04-04567). The original field displays the number correctly, but when I put that field in the calculation, it drops the zero and the dash (so it looks like 404567). I've tried putting (NumToText) in the calculation and that doesn't do the trick. Can anyone tell me how I can get the number to display correctly? Thanks in advance!!

Kristine

Version: v6.x

Platform: Mac OS X Panther

[-Queue-]

Yep, change the original field to text, since report number is not a real 'number'.

[HonkyCat]

Thank you, thank you, thank you Old Hand!!

Kristine

Version: v6.x

Platform: Mac OS X Panther