Reverse Data In A Cell / Reverse Cell Contents

Hi -

I am trying to write a formula to reverse data in a cell.

Basically I am converting a number to hex then I want to take that hex string and reverse it.

So it would be something like this my original number is 400001001 my hex number would be 17D787E9 because I am only allowing it to show 8 characters. I want to reverse the 17D787E9 to read 9E787D71.

My question is:

How can I reverse that cell?
I have searched google and this forum and can't seem to figure it out.

I am sure I could do it in VB but I don't know any VB code.

Thanks for your help!

With
A1 containing a numeric value...eg 400001001

Try this:

Create a Custom Function in VBA:
•Alt+F11.....to open the VBA Editor
•Right-Click on the workbook name in the Project window
•••Insert.Module

In that new module, paste the following code:

Please Login or Register  to view this content.

Back on your worksheet:

Please Login or Register  to view this content.

In the above example, the formula returns: 9E787D71

Is that something you can work with?

To protect the VBA code....
In the VBA Editor:
Tools.VBAProject_Properties.Protection tab...set the visibility and password

If you want to password protect the workbook or worksheet...
From the ribbon:
Home.Format.Protect_Sheet...adjust the settings.

If you use a password...make sure you won't forget it or lose it.