So I copied and pasted some data from an email into excel. When I attempt to do a simple product formula......it all results in 0. What could be happening? I've attempted a funky trim macro that I learned on here and have formatted the text as general and as number to see if that could help. I've even tried to just paste value....nothing. You will see how simple this should be...see below:
*38.3676 *0.019548 0 <-formula is =PRODUCT(A2,B2)
*38.3676 *0.130318 0
*39.4576 *0.019008 0
*39.4576 *0.126718 0
*39.5307 *0.018973 0
*39.5307 *0.126484 0
What gives!?? Any help would be greatly appreciated!!
*38.3676 *0.019548 0 <-formula is =PRODUCT(A2,B2)
*38.3676 *0.130318 0
*39.4576 *0.019008 0
*39.4576 *0.126718 0
*39.5307 *0.018973 0
*39.5307 *0.126484 0
What gives!?? Any help would be greatly appreciated!!