13E2 or 1.30E+03 format problem
 

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


--
hywt
------------------------------------------------------------------------
hywt's Profile: http://www.excelforum.com/member.php...o&userid=27656
View this thread: http://www.excelforum.com/showthread...hreadid=487913

13E2 or 1.30E+03 format problem
 

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


hywt wrote:
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


--
hywt
------------------------------------------------------------------------
hywt's Profile: http://www.excelforum.com/member.php...o&userid=27656
View this thread: http://www.excelforum.com/showthread...hreadid=487913

13E2 or 1.30E+03 format problem
 

Do you know if there's any way to change cells that have already been
entered?

Thanks


--
hywt
------------------------------------------------------------------------
hywt's Profile: http://www.excelforum.com/member.php...o&userid=27656
View this thread: http://www.excelforum.com/showthread...hreadid=487913

13E2 or 1.30E+03 format problem
 

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


hywt wrote:
Do you know if there's any way to change cells that have already been
entered?

Thanks


--
hywt
------------------------------------------------------------------------
hywt's Profile: http://www.excelforum.com/member.php...o&userid=27656
View this thread: http://www.excelforum.com/showthread...hreadid=487913