Displaying Percent Sign

  • Thread starter Thread starter Tony P.
  • Start date Start date
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
 
With your data in Col A starting A1, in B1 put =TEXT(A1,"#%") and copy down. Then select all and
copy and paste special as values. Then delete Col A. Data will now be text only.
 
Back
Top