Click here to Skip to main content
14,773,652 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:

how do I format my cells in an excel table to a date format in my excel sheet?

please help....

Have a look here: Format a date the way you want[^]
thanks for the is the answer.....

Sub Macro()
On Error Resume Next


Sheet1.Range("B:B").NumberFormat = "m/d/yyyy"
End Sub
yep have tried this but the problem when I select the date format I want the sample don't show and my cell is not formatted.
Richard MacCutchan 9-Apr-14 9:16am
Then you must be doing it wrong. Select the cell and then either right click and select Format Cells, or choose Format from the menu. It works in all versions of Excel.
Maciej Los 9-Apr-14 9:21am
This is not an answer. Please, delete it to avoid down-voting.
If you want to post comment, please, use "Have a question or comment" widget.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900