Change text with leading zeros into decimal

  • Thread starter Thread starter Amanda
  • Start date Start date
A

Amanda

Hello,
I am trying to change about 7,000 records right now, so I need som
help that will not include manual changes. There is a column of tex
data that needs to be changed into decimals; sounds easy, but many o
them have leading zeros, which I need to stay. So I need the followin
transfrmation:
0003456 into .0003456

Can anyone please help me !!!
Thanks!!!
 
Hi
try the following formula in an adjacent column (if A stores your
values):
=VALUE("0." & A1)
copy this down

Afgter this you can copy the entire helper column and use 'paste
special - Values' to delete the formulas
 
THANK YOU SO MUCH!!!!! I have been struggling with tha for about an hou
now. You have saved me so much time!!
 
Back
Top