How to convert into number?

E

Eric

Does anyone have any suggestions on how to convert following code into numbers?
There is a code in cell A1 05SG07.
The format for the code is 2-digit numbers + 2 char + 2-dgit numbers
If the char is SG, then it converts to 270, then 270 + 05 + 07/60 = 275.117
05 comes from the first 2-digit numbers and 07 comes from the last 2-digit
numbers.
275.117 should be returned in cell B1.
Does anyone have any suggestions on how to convert it into number?
Thanks in advance for any suggestions
Eric
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to convert the values into 3 digits? 5
How to convert text "JAN" into number 1? 9
Excel Convert word into numbers and back 4
How to set the value? 6
How to determine char or number? 4
How to set the value - 28 Nov? 1
i want to convert decimals into time format 3
This cell contains a date string rep. with only 2 digits for the y 5

Top