Forum Discussion
Solved
Search and change in exel
hi i want to change any number xxx-xxxx to o4-xxx-xxxx how can i do it thank you
Hi Ely,
If these numbers are real numbers (not in text format), you could select them all, and then press Ctrl+1 to open the Format Cell dialog box.
When the Format Cell dialog box pops up, select Custom category, then copy the below format into the Type box:
[<=9999999]o4-###-####;(###) ###-####
Then hit OK.
Hope that helps
Haytham
Hi Ely,
If these numbers are real numbers (not in text format), you could select them all, and then press Ctrl+1 to open the Format Cell dialog box.
When the Format Cell dialog box pops up, select Custom category, then copy the below format into the Type box:
[<=9999999]o4-###-####;(###) ###-####
Then hit OK.
Hope that helps
Haytham
thank you Haytham