| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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? |
|
#2
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Help with data not getting plotted | Charts and Charting in Excel | |||
| Running Data Table using an input that triggers DDE linked data | Excel Discussion (Misc queries) | |||
| I need a macro to find cut and paste data to new cell | Excel Discussion (Misc queries) | |||
| I need a macro to find cut and paste data to new cell | Excel Discussion (Misc queries) | |||
| Dragging cell data | Excel Discussion (Misc queries) | |||
Linear Mode
