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

Tagged with

#Excel alternatives for data analysis
#rows.com
#real-time data collaboration
#real-time collaboration
#natural language processing for spreadsheets
#generative AI for data analysis
#Excel compatibility
#Excel alternatives
#Dividend
#real number
#TRUE number
#FALSE number
#equations
#manual delete
#Find & Replace
#cell
#keep
#use
#feature
#part