ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   How do I create a hexidecimal autofill list? (https://www.excelbanter.com/excel-worksheet-functions/183510-how-do-i-create-hexidecimal-autofill-list.html)

Eric Rosenberg

How do I create a hexidecimal autofill list?
 


David Biddulph[_2_]

How do I create a hexidecimal autofill list?
 
Create your list in decimal, then use the DEC2HEX function.
--
David Biddulph

"Eric Rosenberg" <Eric wrote in message
...




Dave Peterson

How do I create a hexidecimal autofill list?
 
You could put a formula like this in A1 and drag down:
=DEC2HEX(ROW())

If you wanted to start in A15 with 1, you could use:
=DEC2HEX(ROW()-14)


Eric Rosenberg wrote:

--

Dave Peterson


All times are GMT +1. The time now is 11:47 PM.

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