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? |
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? |
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? |
All times are GMT +1. The time now is 09:22 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com