Use a helper column and do the conversion there.

"Tim Lomax" wrote:

need to change a cell from english numbers ex: 1.000 to metric ex: 25.4
automaticly when entering the value. Is this possiable any suggerstions or
work arounds?