In article ,
says...
i have a column of numbers that I am pasting into a worksheet and they are 13
digits. i just need they listed as they are no funtion to
them(mathematical). how do i format that column so that the number appears.
i see it in the preview above when i highlight on it. but when it is in the
cell it has the + sign

One option as others have indicated is to format the column as text
*before* entering the data.

Another option that will work with existing values as long as you have
no numbers with leading zeros is to use the Number format (zero
decimals and optional 'thousands separator') and increase the column
width so that XL shows a 12 digit number in its entirety.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions