try this macro

Select the range and run the macro

Sub quote()
For Each r In Selection
With r
..Value = .Value
End With
Next
End Sub





On Oct 21, 10:14*am, Unknown User
wrote:
How to remove the symbol sign like ' when the data is exporting from
accounting software to excel? *I did tried from replaced method but it
doesn't work as the format of the file.

Your assistance is really help. *Thank you.