Issue with Excel 2003

[Good Intentions]

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?

[Niek Otten]

<as you can see it's wider>

No. Both are ASCII 45

--
Kind regards,

Niek Otten

"Good Intentions" <Good.Intentions.261vnm_1144675502.9036@excelforum-nospam.com> wrote in message
news:Good.Intentions.261vnm_1144675502.9036@excelforum-nospam.com...
>
> 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: http://www.excelforum.com/member.php...o&userid=33330
> View this thread: http://www.excelforum.com/showthread...hreadid=531508
>

[Niek Otten]

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 Otten


"Niek Otten" <nicolaus@xs4all.nl> wrote in message news:unzpm%23KXGHA.3800@TK2MSFTNGP03.phx.gbl...
> <as you can see it's wider>
>
> No. Both are ASCII 45
>
> --
> Kind regards,
>
> Niek Otten
>
> "Good Intentions" <Good.Intentions.261vnm_1144675502.9036@excelforum-nospam.com> wrote in message
> news:Good.Intentions.261vnm_1144675502.9036@excelforum-nospam.com...
>>
>> 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: http://www.excelforum.com/member.php...o&userid=33330
>> View this thread: http://www.excelforum.com/showthread...hreadid=531508
>>
>
>

[Peo Sjoblom]

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

http://nwexcelsolutions.com


"Good Intentions"
<Good.Intentions.261vnm_1144675502.9036@excelforum-nospam.com> wrote in
message news:Good.Intentions.261vnm_1144675502.9036@excelforum-nospam.com...
>
> 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:
> http://www.excelforum.com/member.php...o&userid=33330
> View this thread: http://www.excelforum.com/showthread...hreadid=531508
>