Automatically changing stock tick quotes to decimal-price format.

Kaci · Jun 15, 2005

How to Change a number from ex. 565'6 to 5.65 3/4

JE McGimpsey · Jun 15, 2005

One way:

=LEFT(A1,FIND("'", A1)-1)/100 & TEXT(RIGHT(A1, 1)/8," ?/?")