User community support forum for Apache OpenOffice, LibreOffice and all the OpenOffice.org derivatives

Skip to content

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

Discuss the spreadsheet application
Post a reply

[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
Top

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: 7204
Joined: Sat Nov 08, 2008 8:08 pm
Location: Colorado, USA
Top

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
Top
Post a reply

Return to Calc

Who is online

Users browsing this forum: No registered users and 22 guests

Apache Software Foundation Forum powered by phpBB © phpBB Group
By any use of this Website, you agree to be bound by these
Policies and Terms of Use 		Get OpenOffice
Get OpenOffice