Extract number from text but format answer as a number

[Obewan]

I have the following text in cell A1 and I need a formula which extracts the it answers the number 17.31 in column B - I tried using =Left(A1,5) but it doesn't format into a number and I use this number for other related formulas - any suggestions?

Best Time Trk/Dist:17.31

Thanks in advance!!

Seamus

 

[Anonymous1378]

Perhaps try RIGHT() instead? With a double unary before it?

=--RIGHT(A1,5)

 

[Obewan]

bINGO!! tHANKS A MILLION!