Convert number as text to number as real or integer

[goyete]

Hello, I have a Property with a text field where I can put numbers or for example "-".

I want to make a schedule table with this field and then a formula column.

I want to get 0 if the field is "-" and the number if it isn't "-". My problem is that the data inserted in the field is saved as text, not as number. Is there any way to convert a string text (for example "45") to a number (45).

Thanks!!

[Keith.Brown · Accepted solution]

Take a look at Look at cint() or cdbl(). They will convert a number to an integer or a double which is essentially a reall number.

[goyete]

Thanks Keith, cint("field") works fine for me!

[Anonymous]

it didnt work for me

you can give me example?

example