1 to 3000 in hexidecimal in excel?

X-BEN · 17 Jul 2009 at 10:47

As the topic says I need to write 1 to 3000 in hexidecimal in excel I've searched the internet with no luck it's looks like I'm going to have to write them by hand but I thought first I would ask the brains of the internet!

Any ideas?

Lagmeister · 17 Jul 2009 at 10:51

1 to 3000 in first column

next column =DEC2HEX(A1) then drag that down to copy the function, job done, seriously simple google search excel int to hex, first result

Selekt0r · 17 Jul 2009 at 10:51

Tools>Add-ins
Make sure Analysis Toolpak is checked
use function DEC2HEX(<decimal number>) to return the Hexidecimal you need

*edit* beaten

X-BEN · 17 Jul 2009 at 10:57

Selekt0r said:
Tools>Add-ins
Make sure Analysis Toolpak is checked
use function DEC2HEX(<decimal number>) to return the Hexidecimal you need

*edit* beaten

Thanks selek, thought that was gonna sort it out now I have a different problem.

It's not giving a error in the box, its just blank when i use the dec2hex function

Jono · 17 Jul 2009 at 11:42

http://www.theincline.co.uk/dec2hex.xls ?

X-BEN · 17 Jul 2009 at 15:28

thanks got it to work in the end now i need to do another 300 in hex but with SB infront so (SB should be here)=DEC2HEX(<decimal number>) so it would be SB(hexidecimal number)

last one ill need help with and I appreciate all reply's!

Abyss · 17 Jul 2009 at 15:41

You just want the text "SB" in front?

Just put = "SB" & (your original forumula)

X-BEN · 17 Jul 2009 at 15:46

Thanks very much Abyss couldn't ever describe it to search in google lol. TOP MAN!