| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Cell has an apostrophe and is text
I've downloaded a spreadsheet from the company intranet. One of the columns
I want as numeric has an apostrophe in front of the number. I cut, paste save special, value and I can get rid of the apostrophe, but nothing I do can change the cell to numeric. Any ideas TIA, Carole O |
|
#2
|
|||
|
|||
|
Hi Carole
Copy a empty cell Select your cells Right click on them and choose Paste Special Choose Add OK -- Regards Ron de Bruin http://www.rondebruin.nl "Carole O" wrote in message ... I've downloaded a spreadsheet from the company intranet. One of the columns I want as numeric has an apostrophe in front of the number. I cut, paste save special, value and I can get rid of the apostrophe, but nothing I do can change the cell to numeric. Any ideas TIA, Carole O |
|
#3
|
|||
|
|||
|
It works!!! Thank you, Ron!!
Carole O "Ron de Bruin" wrote: Hi Carole Copy a empty cell Select your cells Right click on them and choose Paste Special Choose Add OK -- Regards Ron de Bruin http://www.rondebruin.nl "Carole O" wrote in message ... I've downloaded a spreadsheet from the company intranet. One of the columns I want as numeric has an apostrophe in front of the number. I cut, paste save special, value and I can get rid of the apostrophe, but nothing I do can change the cell to numeric. Any ideas TIA, Carole O |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Converting Numbers to Text properly | Excel Discussion (Misc queries) | |||
| How do I stop an apostrophe from disappearing? | Excel Discussion (Misc queries) | |||
| Remove the apostrophe (') in Excel cell text values | Excel Discussion (Misc queries) | |||
| Date format collapses diagram | Excel Discussion (Misc queries) | |||
| Add apostrophe | Excel Worksheet Functions | |||
Linear Mode
