View Single Post
  #1   Report Post  
Brett
 
Posts: n/a
Default Numeric cell but shows as string?

I keep getting a #VALUE error when trying to divide two cells. They are
both numbers with decimals. In the error, I click to "show calculation
steps" and see this:

"850.00 "/29634

How can 850.00 be a string if the cell format type is numeric with two
decimal places?

How can I put the 850.00 as numeric and perform the calculation?

Thanks,
Brett