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.

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.

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

"muddan madhu" wrote:

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.

Where do you see that sign?

Can you give an example?

If it is in Excel cell then you can replace it...
--
Always provide your feedback so that others know whether the solution worked
or problem still persists ...


"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.

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
on the cell.

"Sheeloo" wrote:

Where do you see that sign?

Can you give an example?

If it is in Excel cell then you can replace it...
--
Always provide your feedback so that others know whether the solution worked
or problem still persists ...


"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.

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

--
Always provide your feedback so that others know whether the solution worked
or problem still persists ...


"Unknown User" wrote:

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
on the cell.

"Sheeloo" wrote:

Where do you see that sign?

Can you give an example?

If it is in Excel cell then you can replace it...
--
Always provide your feedback so that others know whether the solution worked
or problem still persists ...


"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.

Thank you it work.

"Sheeloo" wrote:

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

--
Always provide your feedback so that others know whether the solution worked
or problem still persists ...


"Unknown User" wrote:

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
on the cell.

"Sheeloo" wrote:

Where do you see that sign?

Can you give an example?

If it is in Excel cell then you can replace it...
--
Always provide your feedback so that others know whether the solution worked
or problem still persists ...


"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.