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. |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
how can I clear an apostrophy in front of number in excel
try copying an unused empty cell. Select your data & edit/paste special,
click Values & Add. "KCESS" wrote in message ... 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. |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
how can I clear an apostrophy in front of number in excel
Another quick way:
Highlight the offending data, then click Data | Text-to-columns then click Finish. Hope this helps. Pete Bob Umlas wrote: try copying an unused empty cell. Select your data & edit/paste special, click Values & Add. "KCESS" wrote in message ... 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. |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
how can I clear an apostrophy in front of number in excel
Corection - not Values and Add, but All and Add.
THe other suggestion(s) will clear the ' from numbers, not text. "Bob Umlas" wrote in message ... try copying an unused empty cell. Select your data & edit/paste special, click Values & Add. "KCESS" wrote in message ... 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. |
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
how can I clear an apostrophy in front of number in excel
Hi,
Assuming your data is Column A, put a formula in Column B. =VALUE(A1) Drag from B1 to the bottom. Select the cells in Column B, copy and Paste Special €“ Value in Column A. This will avoid the error checking and you can use the Vlookup Formula. Regards, Jaleel "KCESS" wrote: 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. |
Reply |
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) |