Post 27 made on Thursday July 20, 2006 at 11:26 |
johnsfine IR Expert |
Joined: Posts: | September 2002 5,159 |
|
|
That function is hex2dec. For example, if cell A1 has a hex number, some other cell could have the formula =hex2dec(A1)
I don't know whether that is enabled by default or is part of the Add-In named "Analysis Toolpak". I always have Analysis Toolpak enabled because the JP1 spreadsheets require that. The JP1 spreadsheets are the only place I've used hex2dec
|
|
|