Convert Number to String

[sopomeres]

I have 'daycount' field which displays number data this way: 1.00

How can I convert it to be displayed as D001? I would like to drop the decimal, convert the number to a 3 character string, and place a "D" prefix. How can this be done?

Thank you.
Chuck

 

[basil3legs]

You can use something like :

Left("D000", 4-Length(totext(DayCount))) + totext(DayCount)

But you have to be make sure Daycount never goes over or equals 9999.5 (totext rounds .5 up) or you will get an error (just test it first), if over 999, you will lose the "D" as well.

 

[Madawc]

Do a formual field:
"D" & totext({daycount}, "000&quot

Madawc Williams
East Anglia, Great Britain

 

[synapsevampire]

Try:

"D"+right(totext({table.field}*.001,3),3)

-k

 

[synapsevampire]

Nice Madawc, simple is better.

-k

 

[sopomeres]

Thank you all!

This site is awesome!

Chuck