Page 1 of 1

Add Decimal and remove '

Posted: Fri Jan 16, 2015 1:07 pm
by steve1040
I have 2000+ rows of data that looks like this

'01000'
'01010'
'V4582'
'32729'
'3602'
'0066'

In every row I need to place the last 2 digits behind a decimal and remove the '

Thanks

Posted: Fri Jan 16, 2015 2:30 pm
by ak47wong
Find what: '(.*)(..)'
Replace with: $1.$2

Posted: Fri Jan 16, 2015 4:40 pm
by steve1040
Thanks!
That worked fine