Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formatting cells for text and numbers
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formatting cells for text and numbers
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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formatting cells for text and numbers
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. -- If this helps, please click the Yes button Cheers, Shane Devenshire "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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formatting cells for text and numbers | Excel Worksheet Functions | |||
Formula Text String: Formatting Text and Numbers? | Excel Discussion (Misc queries) | |||
formatting cells with numbers as text | Excel Discussion (Misc queries) | |||
Formatting from text to numbers | Excel Worksheet Functions | |||
numbers to text with formatting | Excel Discussion (Misc queries) |