Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Leading Apostrophe
Yes but like everyone else I got the leading apostrophe. I guess I should
export as the CVS files and then save as an xls. file. Or has anyone come up with a way to get rid of the apostrophe? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Leading Apostrophe
Try this small macro:
Sub tic_killer() Set rr = ActiveSheet.UsedRange.SpecialCells(xlCellTypeConst ants, xlTextValues) For Each r In rr If r.PrefixCharacter = "'" Then r.Value = r.Value End If Next End Sub -- Gary''s Student - gsnu200803 " wrote: Yes but like everyone else I got the leading apostrophe. I guess I should export as the CVS files and then save as an xls. file. Or has anyone come up with a way to get rid of the apostrophe? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Leading Apostrophe
I got an error message saying the syntac was incorrect and that the security
level was set to low to run the macro. "Gary''s Student" wrote: Try this small macro: Sub tic_killer() Set rr = ActiveSheet.UsedRange.SpecialCells(xlCellTypeConst ants, xlTextValues) For Each r In rr If r.PrefixCharacter = "'" Then r.Value = r.Value End If Next End Sub -- Gary''s Student - gsnu200803 " wrote: Yes but like everyone else I got the leading apostrophe. I guess I should export as the CVS files and then save as an xls. file. Or has anyone come up with a way to get rid of the apostrophe? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Leading Apostrophe
Hi,
What you can alternatively do is that type a number 1 in any cell and then copy this number. Now select the range and then Edit Paste Special Multiply. -- Regards, Ashsih Mathur Microsoft Excel MVP www.ashishmathur.com " wrote in message ... Yes but like everyone else I got the leading apostrophe. I guess I should export as the CVS files and then save as an xls. file. Or has anyone come up with a way to get rid of the apostrophe? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Always have apostrophe | Excel Discussion (Misc queries) | |||
how to remove the apostrophe | Excel Discussion (Misc queries) | |||
Apostrophe In Every Cell | Excel Discussion (Misc queries) | |||
iNSERT LEADING APOSTROPHE | Excel Discussion (Misc queries) | |||
Add apostrophe | Excel Worksheet Functions |