ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Excel version in Cell (https://www.excelbanter.com/excel-discussion-misc-queries/199884-excel-version-cell.html)

Mike

Excel version in Cell
 
I need to get the current Excel version in a cell, if I use =INFO("release")
I get 10 or 11. Is there anything that will give me "Microsoft Office Excel
2003 (11) SP3" in a cell as it shows in "About Microsoft Excel" from menu?

Thanks
Mike

Sheeloo

Excel version in Cell
 
You need to compile a table which maps release number to detailed description
as you have shown and then use VLOOKUP with INFO("releaese") to get what you
want.

You can get the mapping at
http://www.computerliteracy.co.uk/excel_versions.htm.

"Mike" wrote:

I need to get the current Excel version in a cell, if I use =INFO("release")
I get 10 or 11. Is there anything that will give me "Microsoft Office Excel
2003 (11) SP3" in a cell as it shows in "About Microsoft Excel" from menu?

Thanks
Mike



All times are GMT +1. The time now is 04:14 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com