| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
how can I clear an apostrophy in front of number in excel
I know how to change formats - however I have a formatted cell for a 100 +
rows that appear to have an apostrophy as a lead. While I don't see it, I am concluding that because changing formats to general or text is not removing the green box in corner and is not allowing me to do a vlookup using this column of info. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| The number in this cell is formatted as text or preceded by an apostrophe" problem in Excel | Excel Discussion (Misc queries) | |||
| TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
| export excel to Front Page | Excel Discussion (Misc queries) | |||
| Microsoft Excel tries to load front page on opening | Excel Discussion (Misc queries) | |||
| Difference in number of Excel NewsGroups | Excel Discussion (Misc queries) | |||
Threaded Mode
