Convert text to number

Post Reply
billc
Posts: 3
Joined: Tue May 19, 2020 8:56 pm

Convert text to number

Post by billc » Tue Apr 13, 2021 9:51 pm

I have a xlsx spreadsheet imported from an accounting system that has the values presented as text. I need to convert them to numbers to do math on them but almost nothing works. I did find a way to force a number by editing each cell individually but there are a lot of cells.
Excel gives you a flag next to the cell that tells you that the number is stored as text and gives you an option to convert it to a number. It works with a range of cells. Is there any way to do it conveniently in PlanMaker?

SuperTech
SoftMaker Team
SoftMaker Team
Posts: 1428
Joined: Wed Mar 11, 2020 5:31 pm

Re: Convert text to number

Post by SuperTech » Fri Apr 23, 2021 4:49 pm

You can simply copy that range which you want to convert to numbers and overwrite them by right click > Paste Special > Select unformatted text in Paste as > Click OK.

Post Reply

Return to “PlanMaker 2021 for Windows”