Converting text-number to a long data type.

**welchs101** · 11-15-2012, 05:05 PM

I have the following:

Please Login or Register  to view this content.

but for some reason num_1 always ends up being a number equal to 1 and not 1.2.

any ideas?

**Kyle123** · 11-15-2012, 05:09 PM

Please Login or Register  to view this content.

**JieJenn** · 11-15-2012, 05:10 PM

You need to tell Excel that num_1 text type is double. Long is for value with no decimals.

Please Login or Register  to view this content.

**welchs101** · 11-15-2012, 07:37 PM

thanks all of you!

Re: Converting text-number to a long data type.