ExcelBanter - how do I convert numbers to a different base in Excel?

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - how do I convert numbers to a different base in Excel? (https://www.excelbanter.com/excel-worksheet-functions/9220-how-do-i-convert-numbers-different-base-excel.html)

henry

how do I convert numbers to a different base in Excel?

David Jessop

Hi,

IN the Analysis Tool pack there are various functions HEX2DEC, DEC2OCT ...
If you want a more general solution you'd have to write your own conversion
routine. http://mathworld.wolfram.com/Base.html gives a pretty good
description of the algorithm.

HTH, David Jessop

"henry" wrote:

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