View Single Post
  #4   Report Post  
Wayne
 
Posts: n/a
Default

there could be event code attached to the cell (leave
event) that converts the 5B21C2 from Hexidecemal to
decimal then performs some other translation.

Try this in cell C1 "=HEX2DEC(B1)/47779.344"

It might be a starting point for you.

Good luck!

-----Original Message-----
I am taking a class & need help with this question. If

you enter 5B21C2 in
cell B1 of a worksheet (keep in mind it's a make believe

worksheet), the
formula is replaced by the number 125 when you press

enter. What happened?
Second part is using the worksheet from above, you

change the number in cell
B2 from 55 to 65. What happens to the number in the

cell B1? Why? I can't
find anywhere in the book how to (+,-* or /) or any

other math direction
involving a formula like above. Due to that I have no

idea how to answer
either one of these questions. Please Help!
--
thanks
.