13E2 or 1.30E+03 format problem

H

hywt

Hi

My inventory system has storage locations that follow the format 1A1,
1A2 etc. When I get to those with an E in them excel displys them as
an above.

How can I get it to show 13E2, not 1.30E+03?

Thanks
Andy
 
A

Andrew Taylor

Andy,
Either format the cells as text before entering the data, or
enter the data preceded by a single quote (E.g. '13E2) : this will stop
Excel interpreting the codes as numbers.

hth
Andrew
 
A

Andrew Taylor

It might be tricky - for example 1E3 and 10E2 give the same number
and format, so you couldn't reverse-engineer these. If the codes are
always of the precise form abEc where the n's are digits and a<>0
then the formula =LEFT(A1,2)&"E"&LEN(A1)-2 should do it.

A
 
Top