Creating Custom Format

[hunter204]

Good Day,

Is there a way I can create a custom format in excel where I will just type 91625 / 091625 and the result will be automatically display as 9º 16.25 (Degrees, Decimal Minutes) is the format.

Hoping for your quick response and Will appreciate it much. THanks

 

[Rebuild8]

Someone may have a better solution but this worked for me

0° 00"."00

 

[hunter204]

Thanks Rebuild. It's what I am looking for

 

[hunter204]

Someone may have a better solution but this worked for me

0° 00"."00

I tried this format but when you link the cell to other sheet it will show 0:00:00. is there other way that it will copy the result of the current sheet.

 

[Jaafar Tribak]

I tried this format but when you link the cell to other sheet it will show 0:00:00. is there other way that it will copy the result of the current sheet.

Do the same with that cell ie: give it the same custom format as the linked cell.