I have a Excel spreadsheet with two kinds of elements: these include non-integers and integers. I want to select all numbers with decimal points i.e. 3.1415 (non-integers). I don't want to highlight cells that are whole numbers like 314. How do I do this custom selection? My goal is to make all non-integers fixed to 3 decimal places and keep all whole numbers as they are.
I've tried conditional formatting. Is there any way I can do this in a programming language like R's dplyr? Thanks. [[alternative HTML version deleted]] ______________________________________________ R-help@r-project.org mailing list -- To UNSUBSCRIBE and more, see https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.