Thread: Determine decimal
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ithaca Ithaca is offline
external usenet poster
  
Posts: 4
Default Asking too much of Excel?
That seems to have worked perfectly! Thanks!

"Glenn" wrote:

Keep it as text and modify as follows:

=IF(ISERROR(FIND(".",A1)),0,LEN(A1)-FIND(".",A1))

Reply With QuoteReply With Quote