Home |
Search |
Today's Posts |
#1
|
|||
|
|||
12 or more digits in a cell
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 |
#2
|
|||
|
|||
format the cell as text
"scharlene" wrote: 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 |
#3
|
|||
|
|||
Hi Charlene (Scharlene ?), You will have to use a format other than General You could format them as TEXT since it sounds like they are identification and not really treated as numbers. Pasting from plain text is not a problem but pasting from a Rich Text source or from Excel will probably change the formatting, unless you paste as values... But if the are whole numbers up to 15 digits without leading zeros you could use # as your fomat. --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "scharlene" wrote in message ... 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 |
#5
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
copying cell names | Excel Discussion (Misc queries) | |||
Cell color based upon cell value | Excel Discussion (Misc queries) | |||
cell color index comparison | New Users to Excel | |||
Cell Change Color - Need Help | New Users to Excel | |||
VLookup resulting in a blank cell... | Excel Worksheet Functions |