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?
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?
To convert a "date" serial to a text string, you can use the =TEXT() function: https://support.office.com/en-us/art...8-93d29371225c Something like =TEXT(a1,"dd.mm/yyyy") should do what you want.
Recognize that this will turn the date into a text string, which can create issues if you need to use this in further calculations, so I generally recommend that this only be used on values that will not be used in other calculations.
Originally Posted by shg
Not sure I fully understand your question?
Formatting ONLY changes the appearance of a cell, not it's contents. If you have what looks like a date in a cell, and formatting it does not change how it looks, chances are, that is not really a date, but text that looks like a date. Test with =ISNUMBER(Cell-Ref) FALSE indicates TEXT, while dates are actually numerical values
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
PERFECT! Thank you!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks