1 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

How do I get rid of the "Dividend" part while keeping it as a real number

https://preview.redd.it/4l82fmhag01h1.png?width=419&format=png&auto=webp&s=e0ff697b0c88690068f5fe39a2d576e6819c02a4

When I manually delete the "Dividend" part the cell it becomes a TRUE number, but when I try using equations like the one in C1 it makes it a FALSE number. I need to delete the "Dividend" part while keeping it as a real number so I can use it for equations. I also tried the "Find & Replace" feature and that made it into a FALSE number.

submitted by /u/Koish07
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article