Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default Format cells for hexadecimal numbers

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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 11,058
Default Format cells for hexadecimal numbers

Text
--
Gary''s Student - gsnu200909
  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 143
Default Format cells for hexadecimal numbers

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
format cells to whole numbers Nikki Excel Discussion (Misc queries) 2 October 20th 06 12:33 AM
How can I automatically decrement a column in hexadecimal numbers Bonk33r Excel Discussion (Misc queries) 4 August 7th 06 06:59 PM
I want to convert a column of hexadecimal numbers to decimal num xs2sandeep Excel Discussion (Misc queries) 2 April 4th 06 09:46 AM
adding hexadecimal numbers Dave New Users to Excel 3 February 10th 06 08:46 AM
in excel, how to limit digits of negative hexadecimal numbers? [email protected] Excel Discussion (Misc queries) 1 February 1st 06 11:36 PM


All times are GMT +1. The time now is 08:30 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"