Try this slight revision to Castell's suggestion:
=SUBSTITUTE(SUBSTITUTE(A1,0,""),".","")/10^(LEN(SUBSTITUTE(SUBSTITUTE(A1,0,""),".",""))-1)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Neil Goldwasser" wrote:
Unfortunately this did not work. For example, using 100 as my input, the
output was 0.1, whereas it should have been 1.
Using 125 as my input, the output was 12.5, whereas it should have been 1.25.

Standard index form always has one non-zero digit before the decimal point.

Many thanks for your attempt though. Hopefully we'll get there...