M
mari
I have a worksheet with thousands of phone numbers on it,
but not formatted as phone numbers. If I change the
existing numbers' cell format to a custom ###-###-####
format, it won't format the numbers this way unless I
double click in each cell (cell content edit mode) and
press enter.
Unlike regular number formats, it seems as though excel
won't convert existing data to my custom format unless:
-Cell is formatted and THEN number is entered
-If cell has existing number, I must click INTO the cell
(editing mode)
Please help!
much thanks
mari
but not formatted as phone numbers. If I change the
existing numbers' cell format to a custom ###-###-####
format, it won't format the numbers this way unless I
double click in each cell (cell content edit mode) and
press enter.
Unlike regular number formats, it seems as though excel
won't convert existing data to my custom format unless:
-Cell is formatted and THEN number is entered
-If cell has existing number, I must click INTO the cell
(editing mode)
Please help!
much thanks
mari