Page 1 of 1

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

PostPosted: Wed May 15, 2019 11:14 pm
by Craig777
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

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

PostPosted: Wed May 15, 2019 11:41 pm
by FJCC
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.

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

PostPosted: Thu May 16, 2019 12:24 am
by Craig777
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!