Prevent Excel from changing format

tdodge

New Member
Joined
Sep 10, 2002
Messages
2
Using the OutputTo function in Access, I am converting a Access report into and Excel file and my Access text fields are converting to a "general" format field in Excel, preventing the data from transferring correctly. (i.e. I have a access text field with the following data 01310-03, converting to -215310 in Excel.) I have tried everything on the Access side to fix this and know exploring the Excel side. Any suggestions are greatly appreciated.
 

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.

Gates Is Antichrist

Well-known Member
Joined
Aug 15, 2002
Messages
1,961
That is sad. A harsh band-aid would be to concatenate a double-quote before and after the fields as they are created in Access, and dealing with them as necessary in Excel.

Another W.A. technique is to - assuming A1 is imported data, and B1 is available - have concatenating formulas on the receiving end, such as B1=A1 & "" .

You'll want to experiment with this, because I can't reproduce your problem at the moment. These are just the catch-all crutches that come to mind when I'm stuck like you are.
 

NCay

Board Regular
Joined
Jul 15, 2002
Messages
214
there is a data validation command that can be set for just dates/ whole numbers etc, check it out in the help menu see if that'll do the job for you
 

Forum statistics

Threads
1,144,741
Messages
5,726,016
Members
422,653
Latest member
mntsiki

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