Hey guys I got it
I select the whole column and go to Edit->Go to->special->constant and it select all the data(with no blank cells)
Thank you guys for showing me how to change "text" number to "real number"
very appreciated
Mr. Hawly
How do you format a column as any number format?
I also try the other way. However, because my column has many blank cells
e.g
Mill
----
55
Mill
----
55
So after edit special mutiply, my column becomes
Mill
----
55
0
0
0
0
0
Mill
----
55
So is there a way to select the text/number but not the blank cells?
Hey guys I got it
I select the whole column and go to Edit->Go to->special->constant and it select all the data(with no blank cells)
Thank you guys for showing me how to change "text" number to "real number"
very appreciated
Just checking my password is all
Like this thread? Share it with others