| Home |
| Search |
| Today's Posts |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I set up a cell format in Excel?
try =left(A1,2)&"-"&mid(A1,3,2)&"-"&Right(A1,4)
"Jim" wrote: Yes, all locations have exactly the same number of characters. And I was given the list of locations without the hyphens. I am going to be using another program with ODBC to create a specific barcoded label for each location. The locations were given to me like: 1201011A I need it to display as 12-01-011A I do not know much about excel. There are only 4 different letter options at the end of my locations: A,B,C,T. Any help would be appreciated. "bj" wrote: are the numbers in text or are they numeric? with the final A it apears they are text do you build them from other cells or do you just type them in? if you type them in, what do you want to type in to get the results you want? Do all of the locations have exactly the same number of characters? (Don't you hate it when you ask if something can be done, and the standard response is "what do you want done?") "Jim" wrote: I have some rack locations in a warehouse but I need the format to show with hyphens. 12-01-011A And I cannot seem to get any of the custom cell formats to work for me. Any ideas? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Does Excel have a cell format for lat/long in ° min sec format? | Excel Discussion (Misc queries) | |||
| Can Excel 2003 cell link carry with it the source cell format? | Excel Discussion (Misc queries) | |||
| Excel Auto-Format cell to email format | Excel Discussion (Misc queries) | |||
| cell format for date/time in same cell excel 2003 | Excel Worksheet Functions | |||
| How do I copy data in single cell format to a merged cell format | Excel Discussion (Misc queries) | |||
Threaded Mode
