| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Strange vlookup problem | Excel Discussion (Misc queries) | |||
| strange problem: excel file does not open and background freezes i | Excel Discussion (Misc queries) | |||
| Strange Problem | Excel Discussion (Misc queries) | |||
| Strange Excel Problem..... | Excel Discussion (Misc queries) | |||
| Strange Excel problem when opening an Excelbook | Excel Discussion (Misc queries) | |||
Hybrid Mode
