Autoformatting

jtballer

New Member
Joined
Jan 7, 2005
Messages
3
I have to import/export files in and out of access and other programs using excel on a daily basis. All of these files are .CSV files. Some of the data in these files are the same as a date. For example; mar2 or feb-1. Both of these are product numbers and are not intended to be dates. When I open the file in excel it automatically changes them to dates. If I then highlight them and convert them to text I get a 5 digit number like "38413". So each time I open them I have to go through all the lines that I know were converted and change them back to the original data. If I forget or miss just one line then I can corrupt my database. I would like to know 2 things. First, how do I tell Excel not to autoformat (especially dates) Second, can I tell Excel to treat every thing as "Text" when opening a CSV file?
 

Some videos you may like

Excel Facts

Excel Wisdom
Using a mouse in Excel is the work equivalent of wearing a lanyard when you first get to college

Watch MrExcel Video

Forum statistics

Threads
1,123,514
Messages
5,602,093
Members
414,501
Latest member
mdhaumyu

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top