Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
David McRitchie
 
Posts: n/a
Default

Hi Gord,
In other words
"Doesn't work as expected" <grin

Thanks for the explanation, of what the poster would have seen.

"Gord Dibben" <gorddibbATshawDOTca wrote ...
I believe OP was getting his 13 numbers formatted to Scientific Notation.

1.23457E+12 may look like a formula to some people.



"CyberTaz" wrote in message
I'm entering a 13 digit number into a cell and instead of displaying the
number typed excel converts the number into a formula. Is there a way of
turning this off so I get what I type? Thanks




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
How do a convert a "text only (no formulas)" Excel (.xls) file to. Steve Excel Discussion (Misc queries) 1 February 2nd 05 05:55 PM
I can't turn off excel programs with the exit button. What is up. tom moore Excel Discussion (Misc queries) 1 January 15th 05 12:12 AM
duplicating excel formulas mark Excel Discussion (Misc queries) 1 December 29th 04 01:47 PM
Problems with Excel formulas when 2002 upgraded to XP Kathi McGraw Excel Worksheet Functions 0 November 16th 04 05:27 PM
Excel & Copying Formulas JComer Excel Worksheet Functions 1 October 28th 04 07:17 PM


All times are GMT +1. The time now is 01:00 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"