Formatting cells for text and numbers

C

CMEknit

I'm trying to format cells so that I can enter 'F0708' and have it display as
'F-07-08'.

Is there a way to do this? I'm totally stumped. Thanks.
 
X

xlmate

if your data is always a alpha and follow by 4 numberic characters
as in your example F0708

try this formula

=LEFT(A2,1)&"-"&MID(A2,2,2)&"-"&RIGHT(A2,2)

this will give you F-07-08

HTH
--
Pls provide your feedback by clicking the Yes button below if this post have
help you. This will help others to search the archives for result better.


Thank You

cheers, francis
 
S

Shane Devenshire

Hi,

Before you get carried away with this idea consider

Jan 1 2009, Jun 1 2009 and Jul 1, 2009

In you nomenclature these would all get
J0109

That's probably a bad idea. August and April start with A, March and May
with M.
 
Top