Forum Discussion

Ely Livne's avatar
Ely Livne
Copper Contributor
May 26, 2018

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

 

excel
Excel Online
  • Haytham Amairah's avatar
    Haytham Amairah
    May 26, 2018

    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

  • Haytham Amairah's avatar
    Haytham Amairah
    Silver Contributor
    May 26, 2018

    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

Resources