Of course.., you'll need to change the $A1 ref to suit your sheet layout:

Assuming header row
=IF(RIGHT($G2,2)="GB",LEFT($G2,4)/1,LEFT($G2,4)/1000)

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion