Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi
I have a spreadsheet that a user is having problems with. One of the columns contains a job name which is made up of numbers and letters. If I enter 7E1, it immediately formats the cell to Scientific and turns the information into 7.00E+01 Even if I go in and format the cells to General and try to re-enter the details, it does exactly the same. Is there a way to stop this happening. Regards |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Scientific Notation - Suppression of Auto-formatting | Excel Discussion (Misc queries) | |||
cell formatting ends up scientific? | Excel Discussion (Misc queries) | |||
Formatting as TEXT as opposed to scientific notation | Excel Discussion (Misc queries) | |||
Number Formatting/Scientific notation | Excel Discussion (Misc queries) | |||
Scientific Formatting takes over - how to stop... | Excel Discussion (Misc queries) |