Please Help: Download into Excel from different Application

fitzroy

New Member
Joined
Dec 28, 2005
Messages
4
I have an application that downloads data into excel. However, when the values are dumped into excel certain alphanumeric fields a read as numbers and gets converted into what excel thinks it should be. For example if my application shows 0123, excel shows 123. Is there a way to setup my excel so that any number that is downloaded into excel can considered as text instead of numbers?

Thank you, thank you! :biggrin:
 

Some videos you may like

Excel Facts

Round to nearest half hour?
Use =MROUND(A2,"0:30") to round to nearest half hour. Use =CEILING(A2,"0:30") to round to next half hour.

Watch MrExcel Video

Forum statistics

Threads
1,118,231
Messages
5,571,028
Members
412,355
Latest member
BasicExelHelp
Top