Thread: Formula to get number
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Bernd P Bernd P is offline
external usenet poster
  
Posts: 806
Default Formula to get number
Hello,

=A1*10+A1-10*INT(A1/10)

should do it.

Regards,
Bernd

Reply With QuoteReply With Quote