Is there an option in Excel to stop it showing Exponential Numbers

[colby]

When imputting values into Excel there are certain arrangements of numbers/letters which are taken by Excel to be Exponential.

E.G.
15E20

actually represents a room number. But Excel insists that it is 1.5 +E21

To stop this happening it will have to be somthing in the set up because we bring this figure accross from an AutoCAD routine which automatically opens Excel and sends the data via a DDE link.

Thanks in advance for any help on this matter.
Dave.

 

[JVFriederick]

Try formatting as text before the data is linked.

 

[colby]

Thanks very much.

But I was hoping there would be an easier way round it.I didn't write the routine which is in c++.

Dave

 

[Store300]

Format the cells that the data goes into as text bfore the transfer occurs? Store300

Store300@ftnetwork.com