Remove of '

[Unknown User]

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.

 

[muddan madhu]

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

 

[Unknown User]

Sorry I don't understand and I am not familiar in macro. Anyone could help
for this? Thank you.

 

[Sheeloo]

Where do you see that sign?

Can you give an example?

If it is in Excel cell then you can replace it...

 

[Unknown User]

The sign is show in excel cell just before the context. The replace method
is doesn't work as the sign could be see on fx (formula bar) but not be see

 

[Sheeloo]

Ok.

The ' before the value in the cell makes the value in the cell as TEXT so
even if it contains 123 Excel will treat it as a string "123".

To get rid of ' select the Col
Choose Data|Text to columns
Press Next twice
Click on General and click Finish

 

[Unknown User]

Thank you it work.

Ok.

The ' before the value in the cell makes the value in the cell as TEXT so
even if it contains 123 Excel will treat it as a string "123".

To get rid of ' select the Col
Choose Data|Text to columns
Press Next twice
Click on General and click Finish