Change alignment based on if cell is text or number.

This website has been incredibly helpful with teaching me a lot about the power of excel, so thank you.

I have a fairly simple question that I have not been able to find an answer to online.

What I want to do is use either a conditional formatting or custom formatting to change the alignment of my cells. If a cell contains text I want the cell to be center aligned, but right aligned if it contains numbers. My initial thought is to use indents, but my column widths are all going to be diferent, so that may not be appropriate. It seems like custom formatting might hold a solution, but I don't understand that enough.

Attached is a very simple example of what I want. Thanks for the help in advance.

Also, I cannot use macros at all in my spreadsheet so any solution cannot contain them.

Wow thanks for the lightning fast response.

That works,but I have one follow up question, I want to retain the number formatting where negative numbres are in "()". When I use "* general" the "-" is left alligned and the number is right aligned. Looks super goofy. Any additional insight would be great.

Nevermind I figured out how. Just center aligned the text and then used the "," format for numbers. I can't believe the solution was that easy. Thanks for the help.