This is rather complicated to do, I wanted someone here who help me create a converting formula like here on this webpage.
http://www.earthpoint.us/Convert.aspx

So basically, I want to have an Excel sheet that can convert Degrees Minutes to MGRS (Military) coodinates?

For example>

From DEGRIS DECIMAL MINUTES 41°58.89880', -087°54.40008' to MGRS format 16TDM2489048136

Can anyone please send me a template for this just to get an idea here?

thx