Hi scharlene,

Yet another suggestion, use a custom number format like "0 000 000 000 000"

Enter this using the menu item Format - Cells... click on the custom entry
at
the bottom of the list, enter the format code (all the zeroes and spaces
between
the quotes) in the Type box.

This formats a number as follows
1234567891234 -- 1 234 567 891 234
456789 -- 0 000 000 456 789

Ed Ferrero
http://edferrero.m6.net/

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