Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Stop scientific format
I'm trying to type "7E3" into a cell and the fomat keeps changing to "scientific". If I then go into that cell and try to change the format to "general" then I get the number "7000". I know there is probably a simple answer but it's got me? Appreciate any help -- rjay ------------------------------------------------------------------------ rjay's Profile: http://www.excelforum.com/member.php...o&userid=24856 View this thread: http://www.excelforum.com/showthread...hreadid=384012 |
#2
|
|||
|
|||
Try formatting the cell before entering the value.
Cody "rjay" wrote: I'm trying to type "7E3" into a cell and the fomat keeps changing to "scientific". If I then go into that cell and try to change the format to "general" then I get the number "7000". I know there is probably a simple answer but it's got me? Appreciate any help -- rjay ------------------------------------------------------------------------ rjay's Profile: http://www.excelforum.com/member.php...o&userid=24856 View this thread: http://www.excelforum.com/showthread...hreadid=384012 |
#3
|
|||
|
|||
Either pre-format the cell as Text
or prefix your typing with an apostrophe: '7E3 rjay wrote: I'm trying to type "7E3" into a cell and the fomat keeps changing to "scientific". If I then go into that cell and try to change the format to "general" then I get the number "7000". I know there is probably a simple answer but it's got me? Appreciate any help -- rjay ------------------------------------------------------------------------ rjay's Profile: http://www.excelforum.com/member.php...o&userid=24856 View this thread: http://www.excelforum.com/showthread...hreadid=384012 -- Dave Peterson |
#4
|
|||
|
|||
Thanks, the "text" format works fine. -- rjay ------------------------------------------------------------------------ rjay's Profile: http://www.excelforum.com/member.php...o&userid=24856 View this thread: http://www.excelforum.com/showthread...hreadid=384012 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
csv converting numbers to scientific format | Excel Discussion (Misc queries) | |||
Stop excel emedding (opeing in mail format) when outlook is open. | New Users to Excel | |||
Global fix for scientific number format? | Excel Discussion (Misc queries) | |||
Excel Date Format - Stop? | Excel Worksheet Functions | |||
Excel format changes as I merge into Word document How can I stop | Excel Discussion (Misc queries) |