Panduan pengguna Ulet

Mulai menggunakan Ulet untuk Mac.

Fix Numbers Stored as Text in Ulet on Mac

A value can look like a number while being stored as text. Check the total before changing it so you can tell whether the correction affected the calculation.

Recognize the excluded value

  1. In the practice sheet, B2 contains the text value 12, while B3 and B4 contain the numbers 6 and 20.

  2. B5 contains =SUM(B2:B4). Its result is 26 because the text value is excluded.

  3. Compare the visible entries with the formula’s range before correcting the cell.

The practice total is 26 while the text-stored 12 is excluded.

The practice total is 26 while the text-stored 12 is excluded.

Re-enter the numeric value and verify the total

Select B2 and re-enter 12 as a number, without a leading apostrophe. Press Return. B5 should change to 38. Save and reopen the workbook; the example retained a numeric B2 and a total of 38. Use this small-cell check before applying a correction to a larger range, and preserve text identifiers such as product codes when their leading zeros are meaningful.

The reopened sheet includes the numeric 12 in the total of 38.

The reopened sheet includes the numeric 12 in the total of 38.

Related guide open and save an XLSX workbook.

Checked in the Mac desktop spreadsheet editor with a practice workbook, saved-file inspection, and reopening. Screenshots are real editor captures; tests used an isolated profile and file-picker fixtures.

Ulet

Paket aplikasi perkantoran lengkap untuk produktivitas sehari-hari.

Lihat fitur