Percentage problem in Excel 2003

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
 
J

JLatham

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?
 
Top