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




"CMEknit" wrote:

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.