In a message dated 9/6/02 11:35:38 AM Pacific Daylight Time, [EMAIL PROTECTED] writes:
But, Ed. You are missing the point. Those of us who use Excel have no problem doing exactly what you say....in Excel, if you format a cell as text BEFORE you put 25E5 into it, it works just like you say in Star Office. So, what's the difference? It is only Jeff who can't make this work on his installation of Excel. It is NOT Excel in general that won't do this. Linda Linda, You can not just format for text and have 25E5 work. The reason is that E to Excel means exponent is coming next and Excel treats that as scientific notation. It will produce 2.5 x 10 to the 6 power or with different formatting it will produce the number 2,500,000. One way to solve this is to use the apostrophe before the entry. Now it will work fine with any other entry like 25B5 or C5 etc but not an E. LarryB ============= PCWorks Mailing List ================= Don't see your post? Check our posting guidelines & make sure you've followed proper posting procedures, http://pcworkers.com/rules.htm Contact list owner <[EMAIL PROTECTED]> Unsubscribing and other changes: http://pcworkers.com =====================================================
