Thread: Always enter number as a decimal <1
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Ken Johnson Ken Johnson is offline
external usenet poster
  
Posts: 1,073
Default Always enter number as a decimal <1
Hi Chuck,

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

Ken Johnson

Reply With QuoteReply With Quote