Seppe001

Hello,

One can select a text and convert it to data type 'number'. But, is there also a VBA command for it

txs,
seppe001


Re: Innovate on Office Convert To Number in a macro?

Nilotpal-MSFT

Could you please let us know the version of office you are using




Re: Innovate on Office Convert To Number in a macro?

Nilotpal-MSFT

Hi,

You can always use Cstr(<Expression>) or Str(<Number>) functions to convert a number into string format.

Thanks and regards

Nilotpal MSFT





Re: Innovate on Office Convert To Number in a macro?

Nilotpal-MSFT

Hi,

Do you have any additional questions or query regarding this issue

Thanks and regards

Nilotpal MSFT





Re: Innovate on Office Convert To Number in a macro?

Nilotpal-MSFT

Hi,

I am wondering if the answer given to you was useful or not. Let me know if you need any other help from my side.

Thanks and Regards

Nilotpal MSFT