How to convert number to string

[#1]

Hi Friends,

I have one column with values 01,02,03,87,89,98etc

I want to use match function. How to convert these numbers to string so that It will be easy for me to comparision.

Thanks

Pavan

[jpenuliar]

Numeric to string

see if this is you need.

[salto]

Hi,

try with Text(Trim(Field))

Hope this helps.

[#4]

Hi,

you can use text(field) then the values will be converted to string.

[alexandros17]

If you have 01 you have yet a value in string format, try to add more details to your request

[Anonymous · Accepted solution]

Hello

You can use text(number_field) to convert it to string.

If you want this number with the zeros in the left, you can use text(num(number_field,'00')). This way will keep, for example, "01".

Hope it helps.

Regards,

Gabriel

[#7]

Hi,

try this

Text(field value)