wanting to truncate a cell with numbers and text into workable numbers

I hope that my sample Excel file was attached. If the Excel did not upload I would need help doing it.

I want to change a column of cells such as:

I want the "C" column to look like this that I am putting in "D"

A B C D

3/15/22 .085 Dividend 0.085
4/15/22 .0224 Dividend 0.0224
5/15/22 .085 Dividend 0.085
6/15/22 .0228 Dividend 0.0228
7/15/22 .085 Dividend 0.085
8/15/22 .02216 Dividend 0.02216
9/15/22 .085 Dividend 0.085
10/15/22 .0228 Dividend 0.0228

Thank you.

I tried putting in both of Glenn's suggestions and got this.

I enclosed the actual Excel spreadsheet that I am working on. What am I doing wrong?

Thanks Glenn.

K2N*

JeffreyBrown,

This worked great!

Thank you.

K2N*