Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TugboatEng on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!

Cell Formating

Status
Not open for further replies.

dlabs

Electrical
Joined
Feb 16, 2005
Messages
2
Location
US
I wish to enter and show cells in HEX format.
peferably 0xA4, 0x07, 0x3C, etc.
Also I want to be able to auto fill cells when starting a string 1,2,3,...
In short replace DEC with HEX.

ANY IDEAS?
Thanks
 
With dec2hex function it is easy.

Either create your 1,2,3,4,5,6,7,8,9,10,11 etc in column A and use dec2hex in column B

OR...

Put dec2hex(row(A1)) in cell A1 and copy it down column A


=====================================
Eng-tips forums: The best place on the web for engineering discussions.
 
Thanks but not quite what I need. I can't deal with that for an entire workbook, 36 pages so far.
I use Hex numbers everywhere on the sheets and need to switch the cell formatting like I would from Number to Currency.
I need a Format/Cells/Number/'Base'/'Hex'/'1 byte' function added to the Format Cells dialog box.

Any other ideas?
 
Hi
Its always better to use VBA to do the repetitive task
You can just write a subroutine (you can use Hex function of VBA to convert decimal to hex)
and Run it for the selected cells (any range)





Instruite
--------------------------------------
Ideas that works
Concepts that sells
--------------------------------------
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top