View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
CLR CLR is offline
external usenet poster
 
Posts: 594
Default Always enter number as a decimal <1

Hi Ken..........

Yup, I kinda-sorta backed into my formula........but the good news is, both
work.
Thanks for the enlightenment tho.

Vaya con Dios,
Chuck, CABGx3



"Ken Johnson" wrote in message
oups.com...
Hi Chuck,

=A1/10^LEN(A1) is just as good, unless I'm missing something.

Ken Johnson