We have a requirement to export one big SharePoint 2010 document library to an excel spreadsheet with all the columns including latest version. Since by design, Datasheet view/Export to spreadsheet was never designed to view the version history of a specific column, users are not able to get version value that is critical to them. Some other people may use program (API/Powershell) to export this information but here is the quick workaround to get it through UI.
I’ve added a new column called “MyVersion” as calculated column with Formula as “=Version”. This column will get the value from Version column as displayed in the screenshot.
The Document Library will display the MyVersion column value as Version value.
Now if you export to excel, you will get MyVersion column with correct current version numbers.
You would need to be careful the cache issue and create MyVersion column after the list or library "frozen" with no other changes.