In the attached zip is an Excel spreadsheet that I made a mistake. It is minor (I Hope).
I converted all cells with a number by putting an apostrophe in the first space in the cell. This can be seen
by the green triangle in the upper left hand corner of all the numerical cells in the Excel spreadsheet.
There is also a green triangle in the cells that were originally text.
I then accidentally saved the spreadsheet! I should not have! I now have an Excel spreadsheet
with all numerical cells marked so as to be text. I do not want this. I should not have saved the
spreadsheet after that action. I should have just clicked it away without saving it.
Now I have created a button in the lower area of the spreadsheet that is the exact opposite of the button (and its VBA code)
in the top of the spreadsheet.
I want to remove all apostrophes from all numerical cells that have them. This would also remove apostrophes from the text cells.
I created a button on the bottom and recopied the code that adds a apostrophe, but I tired to make one slight change in the line
c ="'" & c.Value
to
c ="" & c.Value
In other words remove the apostrophe from the selected cells, I can hopefully reverse the error that I made.
The VBA code does not work!
What changes must I make in order for the VBA code to work.
Any help appreciated. Thanks in advance.
Respectfully,
Lou Reed