| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Format cells with numbers and text
i'm trying to make a spreadsheet for work and i'm having trouble. mos of the data is pretty standardized, but there are some cases where can't figure out how to program the "Format Cells - Custom" to displa both numbers and text. most of the data looks like 1234-12-123-1234, and i hit the "Forma Cells" to where i can type in the data without the dashes and the cel would display it with dashes. Here's the kicker...some of our dat needs two letters after the numbers, ie, 1234-12-123-1234AB How do program the cells to where all i have to type is the 13 or 1 alphanumeric without dashes and get it to display properly in th cell? Codes i've tried under the custom cell format a ####-##-###-####?? ####-##-###-####** ####-##-###-####;"";"" ####-##-###-####;"@" ####-##-###-####"@" I guess i need to find out what symbol to use as a variable for text. Thank -- oboe_jo ----------------------------------------------------------------------- oboe_joe's Profile: http://www.excelforum.com/member.php...fo&userid=1607 View this thread: http://www.excelforum.com/showthread.php?threadid=27532 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do I format numbers as text | Excel Worksheet Functions | |||
| format text to numbers | Excel Discussion (Misc queries) | |||
| Convert numbers from text format to number format | Excel Discussion (Misc queries) | |||
| Format text to numbers | Excel Discussion (Misc queries) | |||
| How do i change numbers in text format to number format? | New Users to Excel | |||
Threaded Mode
