Add an apostrophe
El-sol
-
El-sol -
El-sol -
Hello,
I have a list of customer numbers to which I need to add an apostrophe to the left; otherwise, my transfer between Excel and Accpac will not work.
If I have the number 8774 in A1, I tried the following formula:
="'"&A1
and the result is: '8774
but I don't want to see the apostrophe. It's just to convert a number to text, like when you directly type '8774 you don’t see the apostrophe.
I also thought of a find and replace, like:
find anything and replace it with ' followed by that anything
(and I’m trying to avoid using a macro)
thank you
Configuration: Windows 7 / Internet Explorer 8.0
I have a list of customer numbers to which I need to add an apostrophe to the left; otherwise, my transfer between Excel and Accpac will not work.
If I have the number 8774 in A1, I tried the following formula:
="'"&A1
and the result is: '8774
but I don't want to see the apostrophe. It's just to convert a number to text, like when you directly type '8774 you don’t see the apostrophe.
I also thought of a find and replace, like:
find anything and replace it with ' followed by that anything
(and I’m trying to avoid using a macro)
thank you
Configuration: Windows 7 / Internet Explorer 8.0
4 answers
-
Hello,
just try without the apostrophe
=(""&A1)
--
A+
Mike-31
A period of failure is a perfect time to sow the seeds of knowledge. -
Hello
=TEXT(A1;0)
rounds the number to 0 decimal places and converts it to text
Best regards
--
"Imagination is more important than knowledge." A. Einstein -
I will keep the 2 suggestions and I will run tests to see if Accpac recognizes the new result. I'm not there yet.
But I have roughly the same problem with another file where I need to fetch data.
Since my first file has client numbers like 8774, in this other file, the clients are preceded by a 0, e.g., 08774.
So it's not compatible. How can I remove the 0s all at once?
Thanks.
(And I just realized there are client numbers with 3 digits, so in this file, these clients are preceded by 00. E.g., 00217. This won't be easy.) -
