How do I create a hexidecimal autofill list?
|
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 ... |
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