click enter after each cell

[kizzie37]

I have a bunch of numbers that need to be formatted as phone numbers (i.e. xxx-xxx-xxxx) I'm using the Format cells- special- phone number, but it wont convert the number to a phone number until I click enter in each cell. Since I have 200 plus numbers/cells in 3 columns, its taking too long by hnd.

I tired data-text to columns, but that does not work, is there another way?

 

[Micron]

Can't you just select the whole column and apply the format?

 

[ZMyrrh]

Select Your Range Of Cells, Click [Home], In the [Number] section, Click [Dropdown Menus Where It Says General], Click [More Number Formats], In the [Number] section, Click [Custom], Delete everything that is in the [Type:] Box, Insert [###-###-####], Click [OK].

 

[Micron]

Select Your Range Of Cells, Click [Home], In the [Number] section, Click [Dropdown Menus Where It Says General], Click [More Number Formats], In the [Number] section, Click [Custom], Delete everything that is in the [Type:] Box, Insert [###-###-####], Click [OK].

I just selected the column as I said and invoked the format dialog. I have used ctrl+1 for many years since that works no matter where M$ puts access to the darn thing. Then selected Phone from the special option. That's it.

 

[ZMyrrh]

I just selected the column as I said and invoked the format dialog. I have used ctrl+1 for many years since that works no matter where M$ puts access to the darn thing. Then selected Phone from the special option. That's it.

That's really quick! I think they are looking for a different format than the phone number one on there. I might be wrong in that they are only looking for the phone number format in general.

 

[kizzie37]

Select Your Range Of Cells, Click [Home], In the [Number] section, Click [Dropdown Menus Where It Says General], Click [More Number Formats], In the [Number] section, Click [Custom], Delete everything that is in the [Type:] Box, Insert [###-###-####], Click [OK].

I tried this and nothing happened, again the number remained as a 10 digit number until I clicked into the cell and pressed "enter". Same issue as with the other option "Special and then phone Number"

 

[kizzie37]

I just selected the column as I said and invoked the format dialog. I have used ctrl+1 for many years since that works no matter where M$ puts access to the darn thing. Then selected Phone from the special option. That's it.

As I mentioned that doesn't work until I go back into the cell and hit "enter" then it does change, but I have over 200 cells and 3 columns of 200 cells and don't have time to hit enter in every cell

 

[ZMyrrh]

You might have Calculation Set to Manual. If you go to [Formulas], Click [Calculation Options], if it says "Manual", Switch that to Automatic.

 

[kizzie37]

You might have Calculation Set to Manual. If you go to [Formulas], Click [Calculation Options], if it says "Manual", Switch that to Automatic.

No, its not set to manual

 

[SpillerBD]

Format the cells.
Copy the Cells.
Paste Special-Values to apply the new formatting.