Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
 
Posts: n/a
Default in excel, how to limit digits of negative hexadecimal numbers?

how does one limit the number of digits displayed in a negative hexadecimal
number?

e.g., instead of the default 10 digits, somethimes i'd like to have only 3
digits, other times 4.
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gary''s Student
 
Posts: n/a
Default in excel, how to limit digits of negative hexadecimal numbers?

Remember that the hex "digits" are just a string representing the number:


In A1 put -700
in B1 put =DEC2HEX(A1) and you will see FFFFFFFD44
if you want the upper half then use =RIGHT(HEX2DECMAL(A1),4)
if you want the lower half then use =LEFT(HEX2DECMAL(A1),4)
--
Gary''s Student


" wrote:

how does one limit the number of digits displayed in a negative hexadecimal
number?

e.g., instead of the default 10 digits, somethimes i'd like to have only 3
digits, other times 4.

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
Help! How do you get excel to find the x(changes daily, marked in a cell from another formula) highest numbers in a group of numbers and sum them up? C-Man23 Excel Worksheet Functions 3 January 19th 06 10:52 AM
excel floating digits error Bewilder Excel Discussion (Misc queries) 3 October 5th 05 05:56 PM
Excel won't sort numbers correctly martin0642 Excel Discussion (Misc queries) 2 September 27th 05 05:34 PM
How to make excel not round real numbers when making a histogram? Leedawg Charts and Charting in Excel 1 September 21st 05 07:36 PM
Paste rows of numbers from Word into single Excel cell BecG Excel Discussion (Misc queries) 1 December 8th 04 05:55 PM


All times are GMT +1. The time now is 10:24 AM.

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

About Us

"It's about Microsoft Excel"