Other Number Base Systems

[Lost Ninja]

Is it possible to use a non base 10 number system? I have in the past needed to fill a range using hexadecimal (base 16) eg. 01 -> FF, I always end up inputting them manually which take quite a bit of extra work. (Also use base 8 on occasion.)

[NBVC]

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

Also, separate your unrelated questions into 2 separate threads.

[Lost Ninja]

Is that Better?

Sorry figuring out what to put as a title when several different questions are asked is always going to be something I fail at.

I also fail at reading...

[shg]

See DEC2OCT, DEC2HEX, OCT2DEC, and HEX2DEC functions.

[Lost Ninja]

Seen those before but can't work out how to use them for a single cell, I mean I can do =Dec2hex(a1) which converts a1 from dec to hex obviously. But not how to have it work on the same cell. So to auto-fill a range 01-ff I'd need a column of 1-255 and then use the above Dec2hex function.

If I use =dec2hex(1) ... =dec2hex(2) etc then it won't fill a range.

[shg]

You can't do it in a single cell -- that would require VBA.