When I download data into a spreadsheet (2003), any hyphens in the
download are automatically changed to a longer type hyphen. For
example: A hyphen - now looks like — which is wider. This causes a
problem when I'm doing a search or if I then use in Access2003 and
write a query. I was told in another section it is an ASCII 45.
Is there a way to fix this so hyphens are imported as hyphens?--
Good Intentions
------------------------------------------------------------------------
Good Intentions's Profile: www.excelforum.com/member.php...oamp;userid=33330
View this thread: www.excelforum.com/showthread...hreadid=531603You have a response in your other thread.
--
HTH
Bob Phillips
(remove nothere from email address if mailing direct)
quot;Good Intentionsquot;
lt;Good.Intentions.26278a_1144690514.3641@excelfor um-nospam.comgt; wrote in
message news:Good.Intentions.26278a_1144690514.3641@excelf orum-nospam.com...
gt;
gt; When I download data into a spreadsheet (2003), any hyphens in the
gt; download are automatically changed to a longer type hyphen. For
gt; example: A hyphen - now looks like - which is wider. This causes a
gt; problem when I'm doing a search or if I then use in Access2003 and
gt; write a query. I was told in another section it is an ASCII 45.
gt;
gt; Is there a way to fix this so hyphens are imported as hyphens?
gt;
gt;
gt; --
gt; Good Intentions
gt; ------------------------------------------------------------------------
gt; Good Intentions's Profile:
www.excelforum.com/member.php...oamp;userid=33330
gt; View this thread: www.excelforum.com/showthread...hreadid=531603
gt;
Yes, but it didn't tell me how to fix this. I find it hard to believe
that I am the only one that this is causing issues for.--
Good Intentions
------------------------------------------------------------------------
Good Intentions's Profile: www.excelforum.com/member.php...oamp;userid=33330
View this thread: www.excelforum.com/showthread...hreadid=531603
- Jun 04 Wed 2008 20:44
Fixing Hyphens
close
全站熱搜
留言列表
發表留言
留言列表

