[Solved] Can't convert text to numbers Tried text to columns

Discuss the spreadsheet application

[Solved] Can't convert text to numbers Tried text to columns

Postby Craig777 » Wed May 15, 2019 11:14 pm

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
Last edited by robleyd on Thu May 16, 2019 1:00 am, edited 2 times in total.
Reason: Tagged [Solved]
openoffice 4.1.6 Windows 10
Craig777
 
Posts: 2
Joined: Wed May 15, 2019 11:10 pm

Re: Can't convert text to numbers - Tried text to columns

Postby FJCC » Wed May 15, 2019 11:41 pm

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.
Windows 10 and Linux Mint, since 2017
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
FJCC
Moderator
 
Posts: 7160
Joined: Sat Nov 08, 2008 8:08 pm
Location: Colorado, USA

Re: Can't convert text to numbers - Tried text to columns FI

Postby Craig777 » Thu May 16, 2019 12:24 am

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!
openoffice 4.1.6 Windows 10
Craig777
 
Posts: 2
Joined: Wed May 15, 2019 11:10 pm


Return to Calc

Who is online

Users browsing this forum: No registered users and 10 guests