ExcelBanter - Automatically changing stock tick quotes to decimal-price format.

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Automatically changing stock tick quotes to decimal-price format. (https://www.excelbanter.com/excel-worksheet-functions/30905-automatically-changing-stock-tick-quotes-decimal-price-format.html)

Kaci

Automatically changing stock tick quotes to decimal-price format.

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

JE McGimpsey

One way:

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

In article ,
"Kaci" wrote:

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

All times are GMT +1. The time now is 01:21 PM.