T
Tony P.
Hello,
I have a column of percentages in an .xls file. The percentage column
displays the percent sign which is what I want. I need to import this XLS
file into another application. The application recognizes excel files. But
after importing the excel file, instead of displaying percentages such as
5%, 10%, 20%, the column now shows
the decimal equivalent .05, .1, .2. I need to retain the percent sign in the
other application. In excel, I tried reformatting the percent column to
text. But the percent signs were still converted to decimal equivalents in
the other application. I think that if excel sees a percent sign it
automatically stores the percentage as it's decimal equivalent when the file
is saved. It isn't important that the percent column be recognized as
percentages but I need to somehow retain the percent sign. Is there a way to
do this?
Thanks,
Tony
I have a column of percentages in an .xls file. The percentage column
displays the percent sign which is what I want. I need to import this XLS
file into another application. The application recognizes excel files. But
after importing the excel file, instead of displaying percentages such as
5%, 10%, 20%, the column now shows
the decimal equivalent .05, .1, .2. I need to retain the percent sign in the
other application. In excel, I tried reformatting the percent column to
text. But the percent signs were still converted to decimal equivalents in
the other application. I think that if excel sees a percent sign it
automatically stores the percentage as it's decimal equivalent when the file
is saved. It isn't important that the percent column be recognized as
percentages but I need to somehow retain the percent sign. Is there a way to
do this?
Thanks,
Tony