I am having trouble creating spreadsheet with hex numbers by draging the handle.
I can convert the numbers using the dec2hex fourmula but can't use the drag to extend the series.
Thanks for your help
Yes.
A copy and paste for a formula should yield the results you are looking for. Eventhough, the fill handle grab-drag should work. I don't know why it is not...
Maybe paste a sample of your problem and I'll try it out myself...
Thanks for the help, but I am new to excel and not sure how to do it. I tried to copy and paste the formula from 1 to F in hex and it just repeated the formula and not count up.
On 2002-05-04 16:31, dmc1129 wrote:
Thanks for the help, but I am new to excel and not sure how to do it. I tried to copy and paste the formula from 1 to F in hex and it just repeated the formula and not count up.
I hope you have got it resolved by now ... otherwise here is a step by step approach:
1. Create a series starting from cell A1, to say A32 -- you could start the series with 1 in cell A1 in column, and use a step value of 1 with an ending value of 32
-- now this series is in decimal numbers
2. clivk in cell B1 and write the following formula to convert the decimal number in cell A1 to a hexadecimal number in B1
=DEC2HEX(A1)
and copy ythis ato all cells from B2:b32
now all the cells in B1:B32 are in hexadecimal notation.
This way you have created a series of numbers in hexadecimal indirectly.
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.