Preventing Scientific Notation From Autoconverting

[googlebot]

Hello,

In many of my macros I deal with inputting data into Excel that may have the form "27E10" or other such string values.

Unfortunately, Excel seems to automatically convert this (first to 27x10^10, and then, if I try to uncovert it, it is listed as 270000000000) data. I do not know how to make it stop doing this.

It often is a problem when I have data delimited in that form because when I put the data into columns, it automatically is no longer the "27E10" value but instead the above numeric values.

Any way around this would be greatly appreciated!

Thanks,
Googlebot

[mhuston]

In Excel, the CStr function converts a value to a string.

The syntax for the CStr function is:

CStr( expression )

e.g. CStr("27E10")

not sure about needing the quotes

[rwgrietveld]

You could change the NumberFormat of the cell first

Please Login or Register  to view this content.

[googlebot]

I apologize for the delay in responding.

Those work fine when I am making a specific instance, but when I use text to columns with data containing these values (say 1E3%testing%2E5 as a single 'row' of data for example) even if the cell the value is going into is formatted like done above, it converts it.

I cannot seem to find a workaround (other than perhaps doing my own manual text to columns code...).

Thanks again in advance!

[googlebot]

I have figured out a way to do this, but it has brought upon another question which I will ask in a new thread.

[googlebot]

Ok, it can be prevented, but still causes problems as vlookup doesn't work with data formatted as "text."

Any solutions?