Text field that contains a number 1

[hawg9]

I have a text field that contains a number and I need to multiply it by 100 but it is returning an error. Other than re-importing the data, how can I get around this error?

 

[SkipVought]

Hi,

Why would you not want to do it right?

Skip,

_{[red]Be Advised![/red]
The band of elderly oriental musicians, known as Ground Cover, is, in reality...
Asian Jasmine!}

 

[hawg9]

Because I don't have time to try and reconvert at the moment. Do you have any suggestions on how I can get around this temporarily.

 

[SkipVought]

Use the Value function or CInt to convert.

Skip,

_{[red]Be Advised![/red]
The band of elderly oriental musicians, known as Ground Cover, is, in reality...
Asian Jasmine!}