Percentage problem in Excel 2003

  • Thread starter Thread starter Shirley Munro
  • Start date Start date
S

Shirley Munro

Hi

I am having problems with percentages in Excel 2003. When I key in any
decimal values, for example, 0.05 and format this cell to percentage
style, the cell shows 5% but so does the Formula Bar. Previously the
Formula Bar would have continued to show 0.05. My problem is that I
then want to import these percentages in Access and I am getting import
errors possible because of the % symbols being seen as text.

Any suggestions or comments would be much appreciated.

Shirley Munro
 
I can offer a work-around
Set up another column with =VALUE(A1)
assuming A1 had your 5% in it, and it will display as .05, you could then
ignore the 5% text input in Access and use the .05 values?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formatting Percentages/LOOKUP using a Percentage 2
trouble formatting percentages 2
Percentage problem 4
Percentage between two given times in Excel 2
dates as percentages 5
Find last value in column... 3
Percentages in Excel 6
Percentage problems 1

Back
Top