Custom format doesnt seem to handle that unless it is all digits.
Excel Formula To Place A Colon Address Serial Number Of MyI need this because every time I need service, the first thing they ask me is the Model Number and Serial Number of my Modem, which is buried deep inside of a Wall Closet; or, they ask me for an IP or MAC Address which I cannot possibly memorize.So, I need to mix Number Formats with Text Formats for the following Example Cell items.From what I can find, Numbers only allows Text OR Number Formats, but no mixing of the two formats. ![]() Short ones will be aligned right, rather than left like the three examples. Long ones (over 11 digits) will be rounded and displayed in scientific notation. Those containing an E will be interpreted as being written in scientific notation and displayed as such. Now that I have 2 answers, I realize that I did not properly ask my question. I know that I can just Format the Cell as Text and then I can basically put anything in that Cell; but, then I have to type EVERY CHARACTER for each Cell. ![]() Like how you can format the Cell as a Telephone Number and it automatically puts in the spaces, parentheses and hyphens for you. That is what I really want, the Application making it easier for me to enter the data without having to type each identical character, like a period, a space or a colon, for each entry. I already read the Users Guide and there is nothing in there for these particular formats to be automatically entered. I have no idea how it can know whether the number being entered is a MAC address, IP address, or part number. There doesnt seem to be anything that makes each stand out if the dots and dashes are not typed in. In the telephone number example, the software knows it is a telephone number so it knows where to put the dashes. For example is 25025025058 an IP address (250.250.250.58) or a part number (250250-250-58) Is 250250250158 an IP address (250.250.250.158) or a MAC address (25:02:50:25:01:58). Format each so they add the dashes, colons, and dots where desired. Although, maybe someday it can be that smart.What I cant do is your second last sentence, Format each so they add the dashes, colons, and dots where desired. HOW DO I ADD THE DESIRED, REPEATED CHARACTERS WHERE I WANT THEM, without having to constantly type them for each entry.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |