Searching \ for '[OT] Excel decimal to hex conversion?' in subject line. ()
Make payments with PayPal - it's fast, free and secure! Help us get a faster server
FAQ page: www.piclist.com/techref/index.htm?key=excel+decimal+hex
Search entire site for: 'Excel decimal to hex conversion?'.

Exact match. Not showing close matches.
PICList Thread
'[OT] Excel decimal to hex conversion?'
2003\08\05@223230 by Josh Koffman

flavicon
face
Hi all. I have a list of numbers in an Excel file in decimal format. I
would like to tranlate these numbers to hexadecimal format. Is there a
way to do that using Excel? It would save me doing the calculations
manually and reduce that source of error.

Thanks,

Josh
--
A common mistake that people make when trying to design something
completely foolproof is to underestimate the ingenuity of complete
fools.
       -Douglas Adams

--
http://www.piclist.com hint: PICList Posts must start with ONE topic:
[PIC]:,[SX]:,[AVR]: ->uP ONLY! [EE]:,[OT]: ->Other [BUY]:,[AD]: ->Ads

2003\08\05@224309 by R Prosser

flavicon
face
Josh
Try    =Dec2Hex(a,b) where a = the number to convert & b = the size of the
output string ( I think).
Also I think it only works with integers!
- It may also depend on the version of Excell & what addins you have
applied.

Richard P





Hi all. I have a list of numbers in an Excel file in decimal format. I
would like to tranlate these numbers to hexadecimal format. Is there a
way to do that using Excel? It would save me doing the calculations
manually and reduce that source of error.

Thanks,

Josh
--
A common mistake that people make when trying to design something
completely foolproof is to underestimate the ingenuity of complete
fools.
       -Douglas Adams

--
http://www.piclist.com hint: PICList Posts must start with ONE topic:
[PIC]:,[SX]:,[AVR]: ->uP ONLY! [EE]:,[OT]: ->Other [BUY]:,[AD]: ->Ads

--
http://www.piclist.com hint: PICList Posts must start with ONE topic:
[PIC]:,[SX]:,[AVR]: ->uP ONLY! [EE]:,[OT]: ->Other [BUY]:,[AD]: ->Ads

2003\08\05@225133 by Tom Messenger

flavicon
face
At 11:14 PM 8/5/2003 -0400, you wrote:
>Hi all. I have a list of numbers in an Excel file in decimal format. I
>would like to tranlate these numbers to hexadecimal format. Is there a
>way to do that using Excel? It would save me doing the calculations
>manually and reduce that source of error.
>
>Thanks,
>
>Josh

=DEC2HEX(some_number_or_cell_reference)

If this does not work for you, then you need to install the 'add-in' tools
from your source CD. Excel help will instruct you in how to do so.

There will also then be DEC2BIN, HEX2BIN, and OCT2BIN. Notice that only the
most severely impaired will have any use for the octal conversion functions.
HTH
Tom

--
http://www.piclist.com hint: PICList Posts must start with ONE topic:
[PIC]:,[SX]:,[AVR]: ->uP ONLY! [EE]:,[OT]: ->Other [BUY]:,[AD]: ->Ads

2003\08\06@013311 by Robert Rolf

picon face
> There will also then be DEC2BIN, HEX2BIN, and OCT2BIN. Notice that only the
> most severely impaired will have any use for the octal conversion functions.

What? No one programming DEC PDP11's or DataGeneral 1200's anymore?

Robert

--
http://www.piclist.com hint: The list server can filter out subtopics
(like ads or off topics) for you. See http://www.piclist.com/#topics

2003\08\06@025458 by WH Tan

flavicon
face
Try enter this one =DEC2HEX(X, Y) into any cell where

X is the decimal number you wish to convert. you may enter a reference to a
cell consist of the decimal number too.
Y is number of HEX digit you wish to display.

Hope this help.

WH Tan



> {Original Message removed}

2003\08\06@035217 by =?us-ascii?Q?Omer_Yalhi?=

flavicon
face
Do not forget to install the toolpack from add-ins:

Tools:Add-Ins, then select the Analisys Toolpack

Otherwise, it won't work

Omer

{Original Message removed}

2003\08\06@042409 by Alan B. Pearce

face picon face
>What? No one programming DEC PDP11's or DataGeneral 1200's anymore?

Or 8080 micros? IIRC a fair amount of code for these was done using octal
because the way the register addressing is done lends itself to octal. I
seem to remember a fair number of programs where listings where published in
magazines like Byte were actually done as octal.

--
http://www.piclist.com hint: The list server can filter out subtopics
(like ads or off topics) for you. See http://www.piclist.com/#topics

2003\08\06@133050 by gtyler

flavicon
face
I programmed a computer made By ITT in europe that controlled a letter
sorting machine that used octal. It was actually very pleasant to use. The
computer ran at a blistering 20Mhz and had 32K of magnetic memory. It
occopied 3 bays and paper tape and a bank of switches were the only way to
load a program. You had to enter a loader program first, then run the paper
tape. The CPU was made out of 74 series TTL gates that had matched
propagation delays.

George

{Original Message removed}

2003\08\06@140659 by Andrew Warren

flavicon
face
Robert Rolf <spam_OUTPICLISTTakeThisOuTspammitvma.mit.edu> wrote:

> > > There will also then be DEC2BIN, HEX2BIN, and OCT2BIN. Notice
> > > that only the most severely impaired will have any use for the
> > > octal conversion functions.
>
> > What? No one programming DEC PDP11's or DataGeneral 1200's
> > anymore?
>
> Or 8080 micros?

   Or PICs.  Early PIC datasheets used octal, and as I recall,
   Microchip's PIC assembler even defaulted to octal.

   -Andy

=== Andrew Warren -- .....aiwKILLspamspam@spam@cypress.com
=== Principal Design Engineer
=== Cypress Semiconductor Corporation
===
=== Opinions expressed above do not
=== necessarily represent those of
=== Cypress Semiconductor Corporation

--
http://www.piclist.com hint: The list server can filter out subtopics
(like ads or off topics) for you. See http://www.piclist.com/#topics

2003\08\06@215849 by Josh Koffman

flavicon
face
Thanks all for the replies...it worked great!

Josh
--
A common mistake that people make when trying to design something
completely foolproof is to underestimate the ingenuity of complete
fools.
       -Douglas Adams

--
http://www.piclist.com hint: The list server can filter out subtopics
(like ads or off topics) for you. See http://www.piclist.com/#topics

More... (looser matching)
- Last day of these posts
- In 2003 , 2004 only
- Today
- New search...