Macro Variable Code

[CityMPLSEmpolyee]

Is there a macro variable code that will allow the variable to look at Text and read it like a number?
I have numbers that are placed in my spread sheet as Text, and I need to get an Average of a small group of them. I have tried converting them to numbers, but that causes errors for other macros.

Please Login or Register  to view this content.

[davegugg]

You can convert them in the code using the CLng, CInt, CDbl, and CSng functions. For more info see the Type Conversion Functions in the VBA help.

Assuming one of your numbers written as text is in cell A1, it'd look like this:

Please Login or Register  to view this content.

[CityMPLSEmpolyee]

Thank you
I'll try this

[CityMPLSEmpolyee]

this is what I have

Please Login or Register  to view this content.

[CityMPLSEmpolyee]

The numbers that I am trying to work with are pasted in and they have spaces included with them from the original source.

[davegugg]

I ran your code above on some cells with numbers formatted as text and it worked as expected. If it is not working for you could you post a sample worksheet with some numbers that you are not able to average?

[davegugg]

Try this instead:

Please Login or Register  to view this content.

[CityMPLSEmpolyee]

How do I post a sample

[CityMPLSEmpolyee]

excellent it worked perfect.
thank you