A
Aligahk06
Dear All,
Good day !!!!!!!!!
I have a Column data with following values.
0.5"
0.75"
1"
1.5"
2"
3"
4"
6"
8"
10"
12"
.... upto 56"
I want to derive only numerical fielf for some calculation.
I mean i want to fetch from a common formula that yields 0.5,0.75,1,2, and
so on.
For example
Cell b10 contains 0.5" then in cell D10 i want 0.5
Cell b11 contains 0.75" then in cell D11 i want 0.75
and so on.
Please assist ?
Rgds,
Aligahk06
Good day !!!!!!!!!
I have a Column data with following values.
0.5"
0.75"
1"
1.5"
2"
3"
4"
6"
8"
10"
12"
.... upto 56"
I want to derive only numerical fielf for some calculation.
I mean i want to fetch from a common formula that yields 0.5,0.75,1,2, and
so on.
For example
Cell b10 contains 0.5" then in cell D10 i want 0.5
Cell b11 contains 0.75" then in cell D11 i want 0.75
and so on.
Please assist ?
Rgds,
Aligahk06