Hi!
I've recently converted a few hundred lat/long positions into degrees and have cells with degree values formatted as: [t],mmss
My posistions display as (for instance) "59,4302", which is exactly how I want them. I copied the cells with conversion formulas (lat/long to degrees) retaining values only, and I'm left with cells that display correctly but have a value of (the one above) "02.01.1900 11:43:02".
Problem is that I need to create a csv file using the display value, is there a way to somehow make a new row of cells that has the display value as actual value? I'm using Excel 2007, if that matters, and I've tried using RIGHT and MID without any great success.
Hope my question made sense and that someone can help me out. This was harder than expected...
Bookmarks