software

I'm trying to replace text cells that read 1-1, 1-2, 1-3, etc. to be 2-1,
2-2, 2-3, etc. I've been going to Find and finding quot;1-quot; and replacing with
quot;2-quot;, which changes the 1-1, for example to 38749. What am I doing wrong?

Hi

Excel is treating 1-1 etc as a date - and hence it comes up with 38749
(which is 1st Feb).
I would suggest either formatting the cells to Text before you start or
prefixing your entries with '

Andy.

quot;Jaelouquot; gt; wrote in message
...
gt; I'm trying to replace text cells that read 1-1, 1-2, 1-3, etc. to be 2-1,
gt; 2-2, 2-3, etc. I've been going to Find and finding quot;1-quot; and replacing
gt; with
gt; quot;2-quot;, which changes the 1-1, for example to 38749. What am I doing wrong?
Thank you so much! All fixed!

quot;Andyquot; wrote:

gt; Hi
gt;
gt; Excel is treating 1-1 etc as a date - and hence it comes up with 38749
gt; (which is 1st Feb).
gt; I would suggest either formatting the cells to Text before you start or
gt; prefixing your entries with '
gt;
gt; Andy.
gt;
gt; quot;Jaelouquot; gt; wrote in message
gt; ...
gt; gt; I'm trying to replace text cells that read 1-1, 1-2, 1-3, etc. to be 2-1,
gt; gt; 2-2, 2-3, etc. I've been going to Find and finding quot;1-quot; and replacing
gt; gt; with
gt; gt; quot;2-quot;, which changes the 1-1, for example to 38749. What am I doing wrong?
gt;
gt;
gt;

Thanks for the feedback!

Andy.

quot;Jaelouquot; gt; wrote in message
...
gt; Thank you so much! All fixed!
gt;
gt; quot;Andyquot; wrote:
gt;
gt;gt; Hi
gt;gt;
gt;gt; Excel is treating 1-1 etc as a date - and hence it comes up with 38749
gt;gt; (which is 1st Feb).
gt;gt; I would suggest either formatting the cells to Text before you start or
gt;gt; prefixing your entries with '
gt;gt;
gt;gt; Andy.
gt;gt;
gt;gt; quot;Jaelouquot; gt; wrote in message
gt;gt; ...
gt;gt; gt; I'm trying to replace text cells that read 1-1, 1-2, 1-3, etc. to be
gt;gt; gt; 2-1,
gt;gt; gt; 2-2, 2-3, etc. I've been going to Find and finding quot;1-quot; and replacing
gt;gt; gt; with
gt;gt; gt; quot;2-quot;, which changes the 1-1, for example to 38749. What am I doing
gt;gt; gt; wrong?
gt;gt;
gt;gt;
gt;gt;