Formatting cells for letters and numbers

C

CMEknit

I would like to be able to enter 'F0708' in a cell and have it display as
'F-07-08' but can't figure out how to accomplish that.

Can this be done and, if so, how? I'm totally stumped! Thanks.
 
D

David Biddulph

No. Cell formatting works for numbers, but if you have text, that is what
you see.

If you've put F0708 in a cell and you want to see F-07-08, you probably need
another cell with something like
=LEFT(A1)&"-"&MID(A1,2,2)&"-"&RIGHT(A1,2)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formatting cells for text and numbers 2
Merging from an Excel file with graphics 1
Excel does not accept text format! 0
ASK Field Formatting 1
Custom Formating Letters to Numbers while Displaying Letters 2
Macro to select and delete levels of a document 2
Need Help with a VBA subroutine 0
Automatically populate value of cell dependent on adajecent cell 3

Top