| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I create a hexidecimal autofill list?
|
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 ... |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Hexidecimal lookup | Excel Worksheet Functions | |||
| Incrementing a hexidecimal column | Excel Discussion (Misc queries) | |||
| how do i do a consecutive hexidecimal count | Excel Worksheet Functions | |||
| Autofill a list | Excel Worksheet Functions | |||
| create an autofill series! | Excel Worksheet Functions | |||
Linear Mode
