Jan 19 2021 05:50 AM
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 custom number format: (###) ###-####
However, this format is not applicable on the rightmost cell with text because aside from having phone numbers, it also includes dates and words. What formula can be used to have all phone numbers in this format: (###) ###-### and also the date in this format: mm/dd/yy, while keeping text as is? (In this order as well: phone number, date, note)
Any help is greatly valued!! Thank you!
Jan 19 2021 06:07 AM
Jan 19 2021 06:25 AM
@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.