Search and change in exel

[Ely Livne]

hi 

i want to change any number xxx-xxxx  to o4-xxx-xxxx

how can i do it

thank you

[#2 · Accepted solution]

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

[#3]

thank you Haytham