FIXED - I have a few hundred cells with numbers that must be totalled but I can't get them to convert to number format.
I've tried the text to columns, importing / exporting, copy paste, etc.
There has got to be a way to do this other than by hand.
Thank you!
C
[Solved] Can't convert text to numbers Tried text to columns
[Solved] Can't convert text to numbers Tried text to columns
Last edited by robleyd on Thu May 16, 2019 1:00 am, edited 2 times in total.
Reason: Tagged [Solved]
Reason: Tagged [Solved]
openoffice 4.1.6 Windows 10
Re: Can't convert text to numbers - Tried text to columns
Can you upload a file with a few rows of your data. To upload a file, click Post Reply and then look for the Upload Attachment tab just below the box where you type a response.
OpenOffice 4.1 on Windows 10 and Linux Mint
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
Re: Can't convert text to numbers - Tried text to columns FI
FIXED. There were spaces at the end of the numbers. Removed that and then did text to columns and made it text, then text to columns into numbers and it worked.
Thank you for the reply and your help!
Thank you for the reply and your help!
openoffice 4.1.6 Windows 10