what is the length to the field in the database you are exporting from ?

"PSKelligan" wrote:

Hello all!

I have some worksheets that I get from a database and upon exporting them
some items that should be text (Stock numbers with leading zeros) are saved
as Numbers and the leading zeros are removed. Wel... I can easily get the
leading zeros back by formatting to custom"000000000". The problem I am
having however is getting the cells in that column to Update to the new
format. I find that I must dbl-Click in each cell and enter "edit mode" for
each cell to get it to update. Is there any one out there taht knows of the
code t o automate the update as I have thousands of cells to update in this
column each week.


--
Thanks,

Patrick