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 "1-" and replacing with
"2-", which changes the 1-1, for example to 38749. What am I doing wrong?
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 "1-" and replacing with
"2-", 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.
"Jaelou" <[email protected]> wrote in message
news:[email protected]...
> 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 "1-" and replacing
> with
> "2-", which changes the 1-1, for example to 38749. What am I doing wrong?
Thank you so much! All fixed!
"Andy" wrote:
> 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.
>
> "Jaelou" <[email protected]> wrote in message
> news:[email protected]...
> > 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 "1-" and replacing
> > with
> > "2-", which changes the 1-1, for example to 38749. What am I doing wrong?
>
>
>
Thanks for the feedback!
Andy.
"Jaelou" <[email protected]> wrote in message
news:[email protected]...
> Thank you so much! All fixed!
>
> "Andy" wrote:
>
>> 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.
>>
>> "Jaelou" <[email protected]> wrote in message
>> news:[email protected]...
>> > 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 "1-" and replacing
>> > with
>> > "2-", which changes the 1-1, for example to 38749. What am I doing
>> > wrong?
>>
>>
>>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks