i'm cleaning up some data to transfer from a spreadsheet to Access and this
is bugging me

how do i clean up the formatting of a phone number field without Excel
removing the starting 0 from a phone number?

i've changed the format to text but it still deletes the 0 - aaarrrggg!
--
deb