Strange Happenings
 

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.

Strange Happenings
 

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.

Strange Happenings
 

Nice one Marcelo,
That was it,
Thanks,
Regards Alan.
PS, God knows how it got there! I didn't put it there!
"Marcelo" wrote in message
...
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.

Strange Happenings
 

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.

Strange Happenings
 

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" wrote in message
...
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.

Strange Happenings
 

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" wrote in message
...
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.

Strange Happenings
 

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" wrote in message
...
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" wrote in message
...
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.

Strange Happenings
 

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" wrote in message
...
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.