| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How can I get rid of the ' single quote in Excel Worksheet
Dear all,
I am not sure if I am posting my question in the right page, I hope someone can help me out. I used the DTS package in SQL server to put a table's data on an Excel worksheet. However, I discover that a single quote " ' " is placed in front of the values in every cell. This makes the calculation or format change cannot be carried out. How can I get rid of the single quote? I am so frustrated. Thanks. Ivan |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to read a string in excel and include the single quote | Excel Discussion (Misc queries) | |||
| Remove single quote | Excel Worksheet Functions | |||
| How can I get rid of the ' single quote sign in excel worksheet | Excel Worksheet Functions | |||
| adding a single quote and comma to every cell in Excel | Excel Programming | |||
| Removing single quote from an excel sheet | Excel Discussion (Misc queries) | |||
Threaded Mode
