How to convert numbers to text

[TryingToLearn101]

Hi all,

I am on Crystal 2008 and would like to convert my 4-digit decimal numbers to text. This is what I tried before and it didn't work. It always showed 2 digits.
TOTEXT ({sales} / {quantity}, '#.####')

Any advice is greatly appreciated.

Thanks,

TTL101

 

[kray4660]

Totext({sales} / {quantity},4) should work

 

[pmax9999]

Hi TryingToLearn101

It isn't entirely clear to me exactly what the problem is, but if it is always 4 decimal places you want you could use kray4660's approach or amend your approach to:
TOTEXT ({sales} / {quantity}, '#.0000')

Simialrly, if you wanted 4 digits before the decimal point, and padded with zeros for smaller numbers, you could use:
TOTEXT ({sales} / {quantity}, '0000#.0000')

In other words, replacing the "#" placeholder with "0"s will ensure that it is padded with zeros where necessary.

Hope this helps.
Cheers, Pete