Step1: I am making a sample table with text, date and general fields in different columns and make them centrally aligned – vertically and horizontally.
Step 2: Now I will convert the few revenue columns as numbers. See the difference. They all go south (I mean right-aligned). No matter what you do, you can’t make them left or centrally aligned.
Step 3: Here is the simple hack. Copy the table, open a blank PowerPoint and paste as special. Avoid Ctrl+C and Ctrl+V. Ctrl+C the table from Excel but before pasting on PowerPoint, right-click and select the second option (Keep Source Formatting (K)).
Step 4: Now, select the table again on PowerPoint. Copy it and paste back to the Excel. This time you can use Ctrl+C and Ctrl+V.
Step 5: Now, in Excel, you can make those columns centrally aligned like I am doing here.
Hope it fixed your issue. If yes, please hit like and do comment your thoughts here.