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?

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?