Table currency number cannot be centered

1. Select data cell - select Format clear on toolbar - reset center

2. Have you chosen all the numbers
select the text and center it

3.

Can be reset to center

1. Take excel 2010 version as an example, as shown in the figure below, first select the number you want to center, then right-click and select "set cell format" in the pop-up box

4. First of all, please open a blank new EXCEL window and enter a number in any cell. For example, enter 123 in A1. You will find that 123 is on the right. At this time, you set the alignment to center, and your 123 will be in the middle. Excel is very obedient. Do you agree? We all think so

as for why you are not obedient in that form, if you open your file, you may be able to see the clue, but just based on your above description, the chance of guessing is not very big

I'd like to guess one. You may have set special accounting (comma), currency and other formats, or set conditional formats. These formats will take precedence over cell formats. Check the conditional format, or set it to normal or numeric type.

5. Select the cell whose number is not centered, right-click the mouse, select set cell format, and click the align tab to center both the horizontal and vertical directions.

6.

Select a number cell or data range

Ribbon & gt; To start, click the left and right center button

7.

The steps to solve the problem are as follows:

1

8. You may set the cell format as numerical value, and there is no problem if you change the format to normal. The default format is normal when reentering after deletion

9.

1. When inserting a table in word, the text in the table is above the left end, as shown in the figure,