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