Custom formatting a cell

B

Brad E

Our part numbers are either a 5 digit number OR a 5
character set where only the first is Alpha OR a 7 digit,
which is similar to the 5 digit except has a 2 digit add-
on. Examples would be:
12345
76815
A2345
B6247
A234567
B154987

Now, when these are entered into a cell, I would like them
to appear as follows:
123-45
768-15
A 2345
B 6247
A 2345 67
B 1549 87
Can someone help me out with my custom formatting entry?
For the numbers I know it would be 000-00, but how do I
get spaces in the text entries, and do I have to use extra
semicolons to get from positive to negative to zero to
text entries? TIA, Brad E.
 
F

Frank Kabel

Hi
AFAIK this is not possible. You can't have different text parts in your
cell formats for numbers
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Multiple formats in one cell 1
Format a Text Box for Zip Code 8
insert a dash 5
Count Blank Cells with Conditions 3
Return sum of values based on lookup-function 1
VLOOKUP, a table with text and numerics 7
Creating Custom MS-Access Input Masks -- Where can I find the codes to use? 0
Specialized custom number format 4

Top