Hello! The data i want to be displayed have diferent formats eg. "S-001" or "S-001.1" or " S-001/A" or "S-001.1/A".The "S-" part i want to be a prefix that will be added to text no matter what comes after it.Also the number that fallows the prefix should be 3 digits(if cell is filled with "1", excell should return "S-001").I have managed to do it with a custom format cells that looks like this : "S-"00#. But if cell is filled with "1.1", or "1/A", excell wont recognize it and it will return "S-001" instead of "S-001.1" or "S-001/A".Also if i fill cell with "1" i dont want the data to be displayed as "S-001.0".Is it posible to aply a single format to all the cells and my data to be displayed corectly?Thank you!