Hello again,
I'm using a spreadsheet to track some issues and it's pretty much complete (thanks again!) but I just noticed that when I use DEC2HEX it converts it into a hex number different from what I need.
For example, 03406812056 converts to CB0FD398 with DEC2HEX but it should convert to 2267F198. I have the DEC field formatted for text due to the fact that the first 0 is important and is removed using any other format (unsure if that matters for this situation)
Thanks again
Bookmarks