Strange Happenings

[Alan]

Hi All,
I want to enter into an empty cell 'MD',
Just that, no quotes, it stands for 'Managing Director'
The result I get is 1.23457E+17
If I format as text or precede 'MD' with an apossrophe I get 12345669885562
Any ideas any one,
TIA,
Alan.

[Marcelo]

Hi Alan,

take a look at the auto correction list.

HTH
regards from Brazil
Marcelo

"Alan" escreveu:

> Hi All,
> I want to enter into an empty cell 'MD',
> Just that, no quotes, it stands for 'Managing Director'
> The result I get is 1.23457E+17
> If I format as text or precede 'MD' with an apossrophe I get 12345669885562
> Any ideas any one,
> TIA,
> Alan.
>
>
>
>

[Alan]

Nice one Marcelo,
That was it,
Thanks,
Regards Alan.
PS, God knows how it got there! I didn't put it there!
"Marcelo" <Marcelo@discussions.microsoft.com> wrote in message
news:9734A8B1-688C-4B63-9E3F-9ECAE5954F50@microsoft.com...
> Hi Alan,
>
> take a look at the auto correction list.
>
> HTH
> regards from Brazil
> Marcelo
>
> "Alan" escreveu:
>
>> Hi All,
>> I want to enter into an empty cell 'MD',
>> Just that, no quotes, it stands for 'Managing Director'
>> The result I get is 1.23457E+17
>> If I format as text or precede 'MD' with an apossrophe I get
>> 12345669885562
>> Any ideas any one,
>> TIA,
>> Alan.
>>
>>
>>
>>

[Marcelo]

thanks for the feedback

"Alan" escreveu:

> Nice one Marcelo,
> That was it,
> Thanks,
> Regards Alan.
> PS, God knows how it got there! I didn't put it there!
> "Marcelo" <Marcelo@discussions.microsoft.com> wrote in message
> news:9734A8B1-688C-4B63-9E3F-9ECAE5954F50@microsoft.com...
> > Hi Alan,
> >
> > take a look at the auto correction list.
> >
> > HTH
> > regards from Brazil
> > Marcelo
> >
> > "Alan" escreveu:
> >
> >> Hi All,
> >> I want to enter into an empty cell 'MD',
> >> Just that, no quotes, it stands for 'Managing Director'
> >> The result I get is 1.23457E+17
> >> If I format as text or precede 'MD' with an apossrophe I get
> >> 12345669885562
> >> Any ideas any one,
> >> TIA,
> >> Alan.
> >>
> >>
> >>
> >>
>
>
>

[CLR]

>PS, God knows how it got there! I didn't put it there!

AutoCorrect is an OFFICE thing.........could even have come from MSWord.

Vaya con Dios,
Chuck, CABGx3




"Alan" wrote:

> Nice one Marcelo,
> That was it,
> Thanks,
> Regards Alan.
> PS, God knows how it got there! I didn't put it there!
> "Marcelo" <Marcelo@discussions.microsoft.com> wrote in message
> news:9734A8B1-688C-4B63-9E3F-9ECAE5954F50@microsoft.com...
> > Hi Alan,
> >
> > take a look at the auto correction list.
> >
> > HTH
> > regards from Brazil
> > Marcelo
> >
> > "Alan" escreveu:
> >
> >> Hi All,
> >> I want to enter into an empty cell 'MD',
> >> Just that, no quotes, it stands for 'Managing Director'
> >> The result I get is 1.23457E+17
> >> If I format as text or precede 'MD' with an apossrophe I get
> >> 12345669885562
> >> Any ideas any one,
> >> TIA,
> >> Alan.
> >>
> >>
> >>
> >>
>
>
>

[Alan]

AutoCorrect is an OFFICE thing.........could even have come from MSWord.

I do realise that, but I know I've never made an alteration to Auto Correct
that would give the result I desrcibed. I do a lot of e-mailing to and from
from work, maybe someone else did it and it migrated to my home set up?
Regards,
Alan.
"CLR" <CLR@discussions.microsoft.com> wrote in message
news:1F7FD648-3C52-4D21-98DE-A32BF56EC71A@microsoft.com...
> >PS, God knows how it got there! I didn't put it there!
>
> AutoCorrect is an OFFICE thing.........could even have come from MSWord.
>
> Vaya con Dios,
> Chuck, CABGx3
>
>
>
>
> "Alan" wrote:
>
>> Nice one Marcelo,
>> That was it,
>> Thanks,
>> Regards Alan.
>> PS, God knows how it got there! I didn't put it there!
>> "Marcelo" <Marcelo@discussions.microsoft.com> wrote in message
>> news:9734A8B1-688C-4B63-9E3F-9ECAE5954F50@microsoft.com...
>> > Hi Alan,
>> >
>> > take a look at the auto correction list.
>> >
>> > HTH
>> > regards from Brazil
>> > Marcelo
>> >
>> > "Alan" escreveu:
>> >
>> >> Hi All,
>> >> I want to enter into an empty cell 'MD',
>> >> Just that, no quotes, it stands for 'Managing Director'
>> >> The result I get is 1.23457E+17
>> >> If I format as text or precede 'MD' with an apossrophe I get
>> >> 12345669885562
>> >> Any ideas any one,
>> >> TIA,
>> >> Alan.
>> >>
>> >>
>> >>
>> >>
>>
>>
>>

[Gary''s Student]

This must be a Named Constant or Named Range on your computer. That would
explain the value association. The name MD could be assoicated with a cell
with a large value in it.
--
Gary''s Student


"Alan" wrote:

> Hi All,
> I want to enter into an empty cell 'MD',
> Just that, no quotes, it stands for 'Managing Director'
> The result I get is 1.23457E+17
> If I format as text or precede 'MD' with an apossrophe I get 12345669885562
> Any ideas any one,
> TIA,
> Alan.
>
>
>
>

[Alan]

If it is I don't know how it got there. I've used loads of named ranges in
XL sheets in the past but they all have refered to actual ranges like
A45:GH250,
Strange, but solved!
Regards,
Alan.
"Gary''s Student" <GarysStudent@discussions.microsoft.com> wrote in message
news:F3E3E59B-4AFD-4E58-B856-7A3BD819C035@microsoft.com...
> This must be a Named Constant or Named Range on your computer. That would
> explain the value association. The name MD could be assoicated with a
> cell
> with a large value in it.
> --
> Gary''s Student
>
>
> "Alan" wrote:
>
>> Hi All,
>> I want to enter into an empty cell 'MD',
>> Just that, no quotes, it stands for 'Managing Director'
>> The result I get is 1.23457E+17
>> If I format as text or precede 'MD' with an apossrophe I get
>> 12345669885562
>> Any ideas any one,
>> TIA,
>> Alan.
>>
>>
>>
>>