Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Custom Formatting
I'm trying to create a custom format to enter in some data. This is what I've tried thus far and excel won't let me do it @##@-#@@#-####-@#@@ I want to enter data that looks like this: B04Z-0FQ1-2323-U3FY Any help?? -- walkerdayle ------------------------------------------------------------------------ walkerdayle's Profile: http://www.excelforum.com/member.php...o&userid=10021 View this thread: http://www.excelforum.com/showthread...hreadid=486878 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Custom Formatting
You can't create a custom format like that for text, only numbers
You would need an event macro that will convert it but that means changing the values (or you can use a formula in another cell that will do it) -- Regards, Peo Sjoblom "walkerdayle" wrote in message ... I'm trying to create a custom format to enter in some data. This is what I've tried thus far and excel won't let me do it @##@-#@@#-####-@#@@ I want to enter data that looks like this: B04Z-0FQ1-2323-U3FY Any help?? -- walkerdayle ------------------------------------------------------------------------ walkerdayle's Profile: http://www.excelforum.com/member.php...o&userid=10021 View this thread: http://www.excelforum.com/showthread...hreadid=486878 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Custom Formatting
If you enter your data preceded with a single apostrophe, Excel will leave it
alone. -- Gary's Student "walkerdayle" wrote: I'm trying to create a custom format to enter in some data. This is what I've tried thus far and excel won't let me do it @##@-#@@#-####-@#@@ I want to enter data that looks like this: B04Z-0FQ1-2323-U3FY Any help?? -- walkerdayle ------------------------------------------------------------------------ walkerdayle's Profile: http://www.excelforum.com/member.php...o&userid=10021 View this thread: http://www.excelforum.com/showthread...hreadid=486878 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Custom Formatting
Maybe you could enter the 16 character string, then use another cell to display
the nicely formatted version: If you put @##@#@@#####@#@@ in A1 You could use this in B1: =IF(A1="","",IF(LEN(A1)<16,"Error", LEFT(A1,4)&"-"&MID(A1,5,4)&"-"&MID(A1,9,4)&"-"&RIGHT(A1,4))) (all one cell) walkerdayle wrote: I'm trying to create a custom format to enter in some data. This is what I've tried thus far and excel won't let me do it @##@-#@@#-####-@#@@ I want to enter data that looks like this: B04Z-0FQ1-2323-U3FY Any help?? -- walkerdayle ------------------------------------------------------------------------ walkerdayle's Profile: http://www.excelforum.com/member.php...o&userid=10021 View this thread: http://www.excelforum.com/showthread...hreadid=486878 -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
make custom formatting permanent | Excel Worksheet Functions | |||
Custom Formatting for Dates | Excel Discussion (Misc queries) | |||
Custom charts - default formatting | Charts and Charting in Excel | |||
Custom formatting to force a decimal place | Excel Discussion (Misc queries) | |||
Custom Formatting a number | Excel Discussion (Misc queries) |