Text to Numbers

Highlighted
Occasional Visitor

I am a new user. On the previous versions, I could convert text to numbers when I imported data to excel. I have now tried everything I know and the programme won't allow me to adjust the text. This also applies when I try to trim numbers to remove spaces between them.

2 Replies
Highlighted

@AzaniaMaseko  After you bring the text in you can use 'Text to Columns' and you will probably recognize the interface from there.  It is in the 'Data' tab in the 'Data Tools' group as you can see here:

mtarler_0-1596566861799.png

As for 'Trim' I don't know what you are doing.  do you have a cell A1 with:   1 2    3   4      5  6   and using a formula in B1 =TRIM(A1) and it isn't displaying: 1 2 3 4 5 6

 

Highlighted
Additional info.
Link from Microsoft with various options.

Convert numbers stored as text to numbers
https://support.microsoft.com/en-us/office/convert-numbers-stored-as-text-to-numbers-40105f2a-fe79-4...

best regards
Nikolino
I know I don't know anything (Socrates)