Thread: Excel Macro
View Single Post
  #2   Report Post  
Dave O
 
Posts: n/a
Default

You could write code, but don't necessarily have to. You can use this
formula to find all the decimal point in the adjacent cell; it returns
TRUE when the decimal is found and FALSE when it is not. Then sort the
spreadsheet using the TRUE/FALSE column.
=IF(ISNUMBER(FIND(".",A1,1)),TRUE,FALSE)