On Fri, 6 Oct 2006 09:30:02 -0700, Dave F
wrote:

I have a table of data which I need to get into Access in a certain format.
One column of data is giving me trouble.

This column of data is formatted with a custom format, 0000000000. (10
zeroes). I want to change the format of these cells to text, so that if the
text string shown in the cell is, say, 0000037009, then the value shown in
the formula bar when that cell is selected shows 0000037009.

Sounds simple, right? Well, when I select this cell and apply the text
format to it, the leading zeroes are chopped off. It becomes: 37009.

Any thoughts?

If your data is in column A, for example, in a "helper" column, enter the
formula: =TEXT(A1,"0000000000") and copy/drag down.

Then
select the Helper column range
Edit/Copy
select A1
Edit/Paste Special Values
delete the helper column.


--ron