| 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? |
| 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 | |||
Threaded Mode
