Conditional Formatting to Remove Text

Welcome to Excel Forum.
Not sure that this will work in Google but in Excel cells A1 and A3 are actually numbers with decimals portions and A2 is a number without a decimal portion. In Excel you can select A1:A3 and apply the following formula as a conditional formatting rule where the format is set to change the font to white if true:

Formula:

Please Login or Register  to view this content.

Let us know if you have any questions.

Please Login or Register  to view this content.

Try this formula within conditonal format

You may have your terms mixed up here. Conditional Formatting only changes the appearance of a cell - it's format - it does not change the actual cell contents.

The only way you can change a cell's actual contents, is to do it either manually, or through VBA. Other than that, you could use a helper cell/column to reference the cell you want to 'change", and apply he change there through a formula

You can't remove text with conditional format.
You need a formula in in different cell
Or you need VBA

again just to late with my reaction

As Ford suggests you might consider a second column that would only list the dates that have times associated. You would then export the second column (B in the attached file) instead of the original column (A) Use the following formula to populate the second column:

Formula:

Please Login or Register  to view this content.

Let us know if you have any questions.

Happy to help.

If this answered your question, please take a moment to mark the thread as "solved" - it helps keep things neat and tidy lol, and consider adding the reputation to those that helped (see points 2 & 3 below my 1st post to you)