Why convert text?

LibreOfficeSometimes your spreadsheet of numbers won't sort properly, and it may be because the spreadsheet thinks the cells are text.  This article describes how to convert this text into real numbers.

Download CT2N extension

We will start by downloading the CT2N extension.

  1. From the download page, download the .oxt file.
  2. Open LibreOffice
  3. From the menu bar, select Tools > Extension Manager.
  4. Click Add...
  5. Browse to the recently downloaded extension.
  6. Click Open.
  7. Click For all users.
  8. Scroll down and Accept the License Agreement.
  9. Close the Extension Manager dialog box.
  10. Click the button to Restart Now.

You should now see the CT2N button on the main menu. 


Thanks for visiting,