| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Format cells, custom type, delete
When entering locations with alpha numeric, 1a3, 2g4 etc, I run into a
problem with anything that has an E in it. 1e3, 3e3 etc. The display show as 3.00E+2. In the custom format type section I found information. I attempted to delete this type but the delete button is not active. Can anyone help me with thism either by activating this button or telling me what the fix is? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Format cells, custom type, delete
Use Text format type
Dan wrote: When entering locations with alpha numeric, 1a3, 2g4 etc, I run into a problem with anything that has an E in it. 1e3, 3e3 etc. The display show as 3.00E+2. In the custom format type section I found information. I attempted to delete this type but the delete button is not active. Can anyone help me with thism either by activating this button or telling me what the fix is? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| FORMAT Cells - Custom | Excel Discussion (Misc queries) | |||
| Custom format cells - how to make it say < number | Excel Worksheet Functions | |||
| checking that cells have a value before the workbook will close | Excel Worksheet Functions | |||
| Custom Format for hours and minutes | Excel Discussion (Misc queries) | |||
| Custom Format Cells | Excel Discussion (Misc queries) | |||
Linear Mode
