<div>
You're welcome and I'm glad I was able to help.<br />
<br />
In <a href="https://www.experts-exchange.com/M_258447.html" rel="ugc">my profile</a> you'll find links to some articles I've written that may interest you.<br />
Marty - MVP 2009 to 2015, Experts-Exchange Top Expert Visual Basic Classic 2012 to 2014
</div>


You're welcome and I'm glad I was able to help.

In my profile [https://www.experts-exchange.com/M_258447.html] you'll find links to some articles I've written that may interest you.
Marty - MVP 2009 to 2015, Experts-Exchange Top Expert Visual Basic Classic 2012 to 2014

<div>
<div class="content wysiwyg-content">
I have a file with a column that contains numbers with some dashes and spaces that display as text. I have a macro that takes an entry like 1-3 and converts it to 1,2,3. However if the cell contains a space before or after the dash, the macro converts it to &nbsp;03-Jan. How do I trick Excel into reading &quot;- &quot;&nbsp;as a text hyphen and produce the result 1,2,3? I tried adding a line that removes the spaces but as soon as you do that the cell turns to 03-Jan.<br />
<br />
Thanks!<br />
John
</div>
</div>


I have a file with a column that contains numbers with some dashes and spaces that display as text. I have a macro that takes an entry like 1-3 and converts it to 1,2,3. However if the cell contains a space before or after the dash, the macro converts it to  03-Jan. How do I trick Excel into reading "- " as a text hyphen and produce the result 1,2,3? I tried adding a line that removes the spaces but as soon as you do that the cell turns to 03-Jan.

Thanks!
John

How to prevent Excel from turning 1- 3  into a date

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.