| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formatting cells for letters and numbers
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formatting cells for letters and numbers
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) -- David Biddulph "CMEknit" wrote in message ... 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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| calculating a sum from cells that contain letters and numbers | Excel Discussion (Misc queries) | |||
| Sorting Cells on letters and numbers and placing result in one of 3 columns | Excel Worksheet Functions | |||
| Sorting - cells containing numbers, numbers and letters | Excel Discussion (Misc queries) | |||
| Finding Numbers with Cells that also contain letters | Excel Discussion (Misc queries) | |||
| How can I merge 2 cells with numbers and letters? | Excel Worksheet Functions | |||
Linear Mode
