| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
2007 treating Text as a Number
2007 on Vista
Haven't used excel much lately, so, forgive me please, I am a bit rusty I've got a list of data which I will be importing into my crm software Before I do that, I was going to label each contact (row) with where I got the data from In excel I simply added a column and put "V LBM 260608", into the cell I then formatted the cell as text (normally, I'd just prefix the data with " ' " When I drag this down the column, excel is incrementing each item of data by 1 , which would be ok if it was a number, but it is 'text' How do I stop excel doing this? |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
2007 treating Text as a Number
Hold down the Ctrl key when your click and drap, or copy then paste.
HTH, Bernie MS Excel MVP wrote in message ... 2007 on Vista Haven't used excel much lately, so, forgive me please, I am a bit rusty I've got a list of data which I will be importing into my crm software Before I do that, I was going to label each contact (row) with where I got the data from In excel I simply added a column and put "V LBM 260608", into the cell I then formatted the cell as text (normally, I'd just prefix the data with " ' " When I drag this down the column, excel is incrementing each item of data by 1 , which would be ok if it was a number, but it is 'text' How do I stop excel doing this? |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
2007 treating Text as a Number
Bernie
Many thanks for your help Faster than a speeding bullet! On Thu, 26 Jun 2008 14:01:19 -0400, "Bernie Deitrick" <deitbe @ consumer dot org wrote: Hold down the Ctrl key when your click and drap, or copy then paste. HTH, Bernie MS Excel MVP wrote in message ... 2007 on Vista Haven't used excel much lately, so, forgive me please, I am a bit rusty I've got a list of data which I will be importing into my crm software Before I do that, I was going to label each contact (row) with where I got the data from In excel I simply added a column and put "V LBM 260608", into the cell I then formatted the cell as text (normally, I'd just prefix the data with " ' " When I drag this down the column, excel is incrementing each item of data by 1 , which would be ok if it was a number, but it is 'text' How do I stop excel doing this? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how i convert "100" to "hundred"( number to text) in excel-2007 | Excel Worksheet Functions | |||
| If Function Treating Answer as a Text Box and Not a Numeric Box | Excel Discussion (Misc queries) | |||
| How do I stop Excel from treating blank cells as zero? | Excel Worksheet Functions | |||
| How to import a text file to Excel treating all input content are in string. | Excel Discussion (Misc queries) | |||
| Why does this fail? =TEXT(RC3,Number)&" / "&TEXT(R32C,Number) | Excel Worksheet Functions | |||
Linear Mode
