Forum Discussion
Custom Number Format on Multiple numbers & text inside same cell
Hello! My objective is to create a custom number format that can work for phone numbers AND dates inside the same cell. EXAMPLE: On the leftmost cell, I've applied the following cu...
JohnnyB12 A custom number format doesn't have that capability. You would have to use a macro to scan any/all text entered and modify according to your rules or you could use helper columns so you enter it in 1 column but using a sophisticated formula you present the result in another column.
That said, I think you should consider how you have your sheet structured. If this is data entry then structure the sheet so it is entered in corresponding columns. If you are importing data, then use power query or something to help. IMHO, I think you need to step back and look at your situation from another angle.