As stated by others it appears that your source data is a set of Latitude/Longitude coordinates stored in degree minute notation. If the values are stored as text in your excel file try using the following formula to convert the values (this excel formula assumes that you have your X values in column A):
=LEFT(A1,SEARCH(CHAR(161),A1)-1) + (MID(A1,SEARCH(CHAR(161),A1)+1,999) /60)
Here's a breakdown of the functions used in the formula:
- This function is used to parse out the whole number value of your coordinate. The first input (A1) is the cell reference for your input X coordinate value. The second input is the SEARCH function.
- This function is used to search the coordinate value for the degree symbol. The first input is CHAR(161), which will return the degree symbol. The second input is the cell reference for your input X coordinate. Since the SEARCH function will return the position of the degree symbol you need to subtract 1 from it so that the number will be parsed properly.
The second part of the formula calculates the fractional part of the coordinate, which is in decimal minutes.
- This function will parse out the decimal minute part of the coordinate. It uses the same SEARCH function as the first section of the formula but adds 1 to the output since you are trying to parse out the right hand part of the input.
The output from the MID function is then converted to degrees by dividing by 60.
When I tested the above formula with your example X coordinate I got an output of 10.87631.