View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.misc
Alan
 
Posts: n/a
Default 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.