Home > OS >  EXCEL cell alignment
EXCEL cell alignment

Time:10-22

Data in a cell 0 at the beginning of the string can be removed 0, how to avoid?
A column in the data in a cell have a plenty of Numbers or letters, digital default is right-aligned, character left-aligned, how to make a new form data in a cell all default are left

CodePudding user response:

Cell 0 start there are two ways to realize the normal display:
1. The first input single quotation marks within the cell ', then enter 0 and other digital;
2. Select cell right, page Numbers in the cell format, find the "text", select and save the Settings, enter 0 will display properly in the beginning, after

If you want to the cell in the column are displayed left-aligned, you can choose the column and then click left aligned above the icon to go directly,
  • Related