Posted to microsoft.public.excel.misc

Alan

Posts: n/a

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.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Strange vlookup problem	thiver	Excel Discussion (Misc queries)	4	May 30th 06 11:22 PM
strange problem: excel file does not open and background freezes i	EdH	Excel Discussion (Misc queries)	2	April 21st 06 02:00 AM
Strange Problem	Perry	Excel Discussion (Misc queries)	7	April 12th 06 09:52 PM
Strange Excel Problem.....	Sachin Shah	Excel Discussion (Misc queries)	0	November 14th 05 09:36 AM
Strange Excel problem when opening an Excelbook	tmarko	Excel Discussion (Misc queries)	1	June 30th 05 05:41 PM

All times are GMT +1. The time now is 05:33 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us