software

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: www.excelforum.com/member.php...nfoamp;userid=836
View this thread: www.excelforum.com/showthread...hreadid=540684I 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?

quot;Shirley Munroquot; wrote:

gt;
gt; Hi
gt;
gt; I am having problems with percentages in Excel 2003. When I key in any
gt; decimal values, for example, 0.05 and format this cell to percentage
gt; style, the cell shows 5% but so does the Formula Bar. Previously the
gt; Formula Bar would have continued to show 0.05. My problem is that I
gt; then want to import these percentages in Access and I am getting import
gt; errors possible because of the % symbols being seen as text.
gt;
gt; Any suggestions or comments would be much appreciated.
gt;
gt; Shirley Munro
gt;
gt;
gt; --
gt; Shirley Munro
gt; ------------------------------------------------------------------------
gt; Shirley Munro's Profile: www.excelforum.com/member.php...nfoamp;userid=836
gt; View this thread: www.excelforum.com/showthread...hreadid=540684
gt;
gt;