Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
excel question Formats and number pad
A colleague of mine mentioned that when entering data with the number pad as opposed to the row of numbers at the top of the keyboard the format of the cells is changed to text. The problem I am having is that our Chip # column (each tagged animal has a unique chip # for Identification purposes) may consist of numbers alone of numbers and letters. When I make a pivot table it does not class the number 6443322 with all the 6443322's if one is formatted in text and one a number. I get the error green corner of the cell saying number formatted as text and if I change it it still will not work. Does anyone have experience with this that I can solce my problem? Thank you for your help! K -- raindancer ------------------------------------------------------------------------ raindancer's Profile: http://www.excelforum.com/member.php...o&userid=31289 View this thread: http://www.excelforum.com/showthread...hreadid=509583 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
excel question Formats and number pad
I don't think your colleague is correct about the number keypad.
But I would try to keep all my data the same -- all numbers or all text. If you want to convert the text numbers to number numbers, you can: select an empty cell edit|copy select the range to fix edit|paste special|check add Excel will coerce the text numbers to number numbers. If you want to convert the number numbers to text numbers, you can use a helper column and use something like: =a2&"" or =text(a2,"000000000") (use a numberformat you like) Then copy|paste special|values over the original range and delete the helper column. I'd format that column as Text (format|cells|number tab) so that any new entry would be treated as text. raindancer wrote: A colleague of mine mentioned that when entering data with the number pad as opposed to the row of numbers at the top of the keyboard the format of the cells is changed to text. The problem I am having is that our Chip # column (each tagged animal has a unique chip # for Identification purposes) may consist of numbers alone of numbers and letters. When I make a pivot table it does not class the number 6443322 with all the 6443322's if one is formatted in text and one a number. I get the error green corner of the cell saying number formatted as text and if I change it it still will not work. Does anyone have experience with this that I can solce my problem? Thank you for your help! K -- raindancer ------------------------------------------------------------------------ raindancer's Profile: http://www.excelforum.com/member.php...o&userid=31289 View this thread: http://www.excelforum.com/showthread...hreadid=509583 -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
Excel should allow me to change default number formats | Excel Discussion (Misc queries) | |||
Text, Number and Date formats excel 2003 driving experienced user | Excel Discussion (Misc queries) | |||
Maximum Number of Cell Formats | Excel Discussion (Misc queries) | |||
Excel should allow a number formats of HEX, OCT and BIN. | Excel Worksheet Functions |