ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How do I represent data in a cell as hexadecimal without converti. (https://www.excelbanter.com/excel-discussion-misc-queries/2449-how-do-i-represent-data-cell-hexadecimal-without-converti.html)

trosier

How do I represent data in a cell as hexadecimal without converti.
 
I have a worksheet with hexadecimal data. I am trying to create a chart but
the chart will not interpret hex numbers correctly. I know I can convert to
decimal and do it that way. Is there a way I can tell Excel that the numbers
in the cells are hex and have it plot it correctly?

Frank Kabel

Hi
AFAIK you have to convert them first to numerics before plotting them

--
Regards
Frank Kabel
Frankfurt, Germany

trosier wrote:
I have a worksheet with hexadecimal data. I am trying to create a
chart but the chart will not interpret hex numbers correctly. I know
I can convert to decimal and do it that way. Is there a way I can
tell Excel that the numbers in the cells are hex and have it plot it
correctly?





All times are GMT +1. The time now is 04:11 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com