Hi.
here is the Column of dollar $ which i want to convert:
( a small list from a column )
This is an example for Dollar $ :
0.0168
0.1934
0.0996
0.1166
0.0553
0.0562
0.0395
0.0381
which i want to convert like this:
This is an example for Cent of above mentioned Dollars $ :
1.68
19.34
9.996
11.66
5.53
5.62
3.95
3.81
Deleting start "0" and Decimal and putting the decimal after cent.
For example:
From 0.0168 to 1.68
How do i do that and how do i do that for complete column ?
Sorry i am newbie here if msitaken rules.
Thanx
Bookmarks