Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formatting to text - apostrophe does not show
I got a bunch of numbers that look like this 0345N9 and I want to have the
apostrophe Not the quote in front: '0345N9. I have done the regular stuff of going to data, text to columns, apostrophy as text qualifier and then click the botton "text." The cell will show the green triangle as usual on the upper left corner but the apostrophe is not there to be seen. Then when I want to do a vlookup it will not find it because it misses the apostrophe. I tried also to concatenate the cell to an apostrophe, it will not work. Is there another way? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
show apostrophe / single quote in cell | Excel Discussion (Misc queries) | |||
Formatting alignment - can I show text upside down? | Excel Discussion (Misc queries) | |||
Apostrophe vs Text format | New Users to Excel | |||
why is an apostrophe in front of text | Excel Discussion (Misc queries) | |||
Cell has an apostrophe and is text | Excel Discussion (Misc queries) |