Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
How do I format cells so I can enter numbers directly in hex format. I will
then operate on them and also convert to binary or decimal using the hex2bin function. |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Text
-- Gary''s Student - gsnu200909 |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
dont forget excel only can do math on decimal numbers. you can put A in a
cell but excel not see it as 10, just a text. every hex or bin number must be convert to dec to do math. "Ricsastir" wrote in message ... | How do I format cells so I can enter numbers directly in hex format. I will | then operate on them and also convert to binary or decimal using the hex2bin | function. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
format cells to whole numbers | Excel Discussion (Misc queries) | |||
How can I automatically decrement a column in hexadecimal numbers | Excel Discussion (Misc queries) | |||
I want to convert a column of hexadecimal numbers to decimal num | Excel Discussion (Misc queries) | |||
adding hexadecimal numbers | New Users to Excel | |||
in excel, how to limit digits of negative hexadecimal numbers? | Excel Discussion (Misc queries) |