View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Shirley Munro
 
Posts: n/a
Default Percentage problem in Excel 2003


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


--
Shirley Munro
------------------------------------------------------------------------
Shirley Munro's Profile: http://www.excelforum.com/member.php...nfo&userid=836
View this thread: http://www.excelforum.com/showthread...hreadid=540684