Download WPS Office for your device

1. How to set the data format.2. How to enter the correct date and time formats.3. How to make number format and text format convert to each other.4. How to flexibly utilize the custom format.

In this lesson we have studied the following key points:1. How to make number format and text format convert to each other?In WPS Spreadsheets, when the number entered exceeds 11 digits, it will be automatically converted into text.Text format has the following 3 features: it is aligned to the left by default; it is unable to participate in calculation; a green corner prompt will appear in the upper left corner of the cell will. The way to convert text format into number format is as ....

We use powerful PDF in our daily life nearly every day.In our daily work, we may have encountered large PDF files. It not only affects the transmission speed but also takes up too much space. Using the compression feature of WPS Premium can quickly help you to solve this problem.Take this file as an example.1. Click the Tools tab.2. Then click Compress.3. Now a dialog box will pop up. Here, we can choose the compression level. This will determine the image quality of the compressed fil....

When using WPS Writer to create a table, except for the first page, the table on other pages does not display the header row, so we don't know what the data represents in each column. Take this document as an example. Only the first page has the header row. For beginners, they will choose to add a header row above each table manually. It's too much trouble. Today I will teach you a method to quickly set the header row across pages. At this point, we can select the header row, c....

Do you want to layout your articles more efficiently? WPS Office provides us with a useful and practical function: the Word Typesetting function. Navigate to the Home tab, and click the Word Typesetting drop-down button. Then we can see a lot of text typesetting functions.Tips: you can turn on the Show/Hide Paragraph Marks button for subsequent operations.l Insert blank paragraphs In this document, for example, there is no space between paragraphs, which looks dense and does not fit th....

No matter you are a student, teacher, or business professionals, you can create and edit documents efficiently by WPS Writer as text editors. When we save a document that contains pictures, it happens that the images are compressed.How can we to prevent this? Click Menu and then Options, select General and Save on the left, and then check Do not compress images in the file" at Save on the right. In addition, we can also set the pixel resolution of the image at Set default target output....

When viewing a worksheet with a large amounts of data in the WPS Spreadsheet, we can't see the title row if we drag the scroll bar. Therefore, we won't be able to know exactly what each column of data represents. So how can we freeze a row or column for us to check it more conveniently? Today I'm going to introduce you to a practical feature, Freeze Panes. Take this table as an example. Click the Home tab, then click the Freeze Panes button. You can see that there are three....

When we are using WPS Document, we often encounter situations where we need to insert pictures into the document. So, how can we insert pictures and set images in the Document? Take this speech draft as an example.1. Click the Insert button on the tab of the upper side of the screen.2. Then select the drop-down button of Picture.3. Click From File in the popup window.4. Select the image you want to insert, and click Open. We can now see that the picture is inserted into the document su....