| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Cell changes from General format to Scientific
Entered 123E305 in a cell having the format of General. It returns 1.23E+307
and changes the cell format to Scientfic. Entered 123E306 in a cell having the format of General. It returns 123E306 and retains the General formatting. What would cause this? Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can cell format come from and change with reference cell format | Excel Discussion (Misc queries) | |||
| Change CSV-load cell format from GENERAL to TEXT for numbers? | Excel Discussion (Misc queries) | |||
| Possible Lookup Table | Excel Worksheet Functions | |||
| Copy cell format to cell on another worksht and update automatical | Excel Worksheet Functions | |||
| can't format cell - have tried unlocking and unprotecting | Excel Discussion (Misc queries) | |||
Threaded Mode
