software

I have found that when I import information into Excel 2003, Hyphens are
not converted to a longer type symbol (almost like 2 hypen widths).
I've seen it in Microsoft Access 2003 also. How can I get hyphens to
remain as hyphens. For example, if I type a hyphen it shows up as -.
But here's a copy of what gets imported —. as you can see it's wider.
This gets annoying especially when I use Access and what to type in
something for a query. Can you help me?--
Good Intentions
------------------------------------------------------------------------
Good Intentions's Profile: www.excelforum.com/member.php...oamp;userid=33330
View this thread: www.excelforum.com/showthread...hreadid=531508lt;as you can see it's widergt;

No. Both are ASCII 45

--
Kind regards,

Niek Otten

quot;Good Intentionsquot; lt;Good.Intentions.261vnm_1144675502.9036@excelfor um-nospam.comgt; wrote in message
news:Good.Intentions.261vnm_1144675502.9036@excelf orum-nospam.com...
gt;
gt; I have found that when I import information into Excel 2003, Hyphens are
gt; not converted to a longer type symbol (almost like 2 hypen widths).
gt; I've seen it in Microsoft Access 2003 also. How can I get hyphens to
gt; remain as hyphens. For example, if I type a hyphen it shows up as -.
gt; But here's a copy of what gets imported -. as you can see it's wider.
gt; This gets annoying especially when I use Access and what to type in
gt; something for a query. Can you help me?
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=531508
gt;
This response is from a newsgroup; your question has been (automatically) forwarded to here. I followed the link to your original
post at EXCELTIP.com and there indeed is a difference between the two hyphens. The long one is ASCII 151, the short one 45.
Sorry I can't help you any further

--
Kind regards,

Niek Ottenquot;Niek Ottenquot; gt; wrote in message ...
gt; lt;as you can see it's widergt;
gt;
gt; No. Both are ASCII 45
gt;
gt; --
gt; Kind regards,
gt;
gt; Niek Otten
gt;
gt; quot;Good Intentionsquot; lt;Good.Intentions.261vnm_1144675502.9036@excelfor um-nospam.comgt; wrote in message
gt; news:Good.Intentions.261vnm_1144675502.9036@excelf orum-nospam.com...
gt;gt;
gt;gt; I have found that when I import information into Excel 2003, Hyphens are
gt;gt; not converted to a longer type symbol (almost like 2 hypen widths).
gt;gt; I've seen it in Microsoft Access 2003 also. How can I get hyphens to
gt;gt; remain as hyphens. For example, if I type a hyphen it shows up as -.
gt;gt; But here's a copy of what gets imported -. as you can see it's wider.
gt;gt; This gets annoying especially when I use Access and what to type in
gt;gt; something for a query. Can you help me?
gt;gt;
gt;gt;
gt;gt; --
gt;gt; Good Intentions
gt;gt; ------------------------------------------------------------------------
gt;gt; Good Intentions's Profile: www.excelforum.com/member.php...oamp;userid=33330
gt;gt; View this thread: www.excelforum.com/showthread...hreadid=531508
gt;gt;
gt;
gt;
You could use something like this in a macro that will convert them to long
hyphens

Selection.Replace What:=Chr(45), Replacement:=Chr(151), LookAt:=xlPart, _
SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
ReplaceFormat:=False--

Regards,

Peo Sjoblom

nwexcelsolutions.comquot;Good Intentionsquot;
lt;Good.Intentions.261vnm_1144675502.9036@excelfor um-nospam.comgt; wrote in
message news:Good.Intentions.261vnm_1144675502.9036@excelf orum-nospam.com...
gt;
gt; I have found that when I import information into Excel 2003, Hyphens are
gt; not converted to a longer type symbol (almost like 2 hypen widths).
gt; I've seen it in Microsoft Access 2003 also. How can I get hyphens to
gt; remain as hyphens. For example, if I type a hyphen it shows up as -.
gt; But here's a copy of what gets imported -. as you can see it's wider.
gt; This gets annoying especially when I use Access and what to type in
gt; something for a query. Can you help me?
gt;
gt;
gt; --
gt; Good Intentions
gt; ------------------------------------------------------------------------
gt; Good Intentions's Profile:
gt; www.excelforum.com/member.php...oamp;userid=33330
gt; View this thread: www.excelforum.com/showthread...hreadid=531508
gt;