lezawang
Well-known Member
- Joined
- Mar 27, 2016
- Messages
- 1,805
- Office Version
- 2016
- Platform
- Windows
Hi
I just watched a video of excelisfun, the link below and he suggested to change text to numbers by using -- in front of a function Right().
My question, why he did not suggest to go to Home-->Number--> then select number to convert to text to number.
Another question. If I have the following numbers in a column (see below please A1:A3). If I change them from number to Text (Home-->number-->Text). They will be aligned to the left side of the cells but if I do for example C1 =A1 +10, I will get 20?
Why is that when A1=10 is a text not a number
<tbody>
</tbody>
Thank you very much.
https://www.youtube.com/watch?v=mjLvi0gu494
I just watched a video of excelisfun, the link below and he suggested to change text to numbers by using -- in front of a function Right().
My question, why he did not suggest to go to Home-->Number--> then select number to convert to text to number.
Another question. If I have the following numbers in a column (see below please A1:A3). If I change them from number to Text (Home-->number-->Text). They will be aligned to the left side of the cells but if I do for example C1 =A1 +10, I will get 20?
Why is that when A1=10 is a text not a number
10 |
20 |
30 |
<tbody>
</tbody>
Thank you very much.
https://www.youtube.com/watch?v=mjLvi0gu494