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? |
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