How to replace a cells value with the result of its formatting

[Sm3tUser]

I have formatted cells as dd/mm/yyyy. However this does not mean the cell value itself changes, it is merely the formatting. How can I turn this formatting into the cell value itself?

 

[Rick Rothstein]

I have formatted cells as dd/mm/yyyy. However this does not mean the cell value itself changes, it is merely the formatting. How can I turn this formatting into the cell value itself?

If I understand your question correctly, this macro should do what you want... just select the cell you want to process and run the macro.

Sub GetCellFormat()
  Selection(1).Value = Selection(1).NumberFormat
End Sub