At 23:15 05/07/2022 +0100, David Deeks wrote:
Sorry Brian, I was just being courteous - I thought if I included
everyone with my follow-up query it would look like I was doubting
your expertise!
Oh, it's perfectly OK to doubt my expertise.
... everything now seems to be hunky dory.
Good-oh!
So "text to columns" converts to text those cells originally entered
as numbers?
No, rather the other way around: your text values are converted to numbers.
The normal use of Text to Columns... is to divide text in one column
into multiple columns. So if you have names such as "David Deeks" in
one column and you use Text to Columns... with Space ticked, you will
get "David" in the original column and "Deeks" in the next column to
the right (with the intervening space helpfully swallowed up). But in
the process, it appears that values are reinterpreted, just as they
would be if the data was entered afresh. So a text value "1000" is
treated as if you had typed 1000, in other words as the number one
thousand, not the four text characters.
Brian Barker
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
