Thread
:
Formatting the Date in Excel
View Single Post
#
2
Dave O
Posts: n/a
Short of writing code, you could enter your numerics only date in cell
A1, for instance: 07142005. Then in B1 write a formula:
=mid(A1,1,2)&"/"&mid(A1,3,2)&"/"&left(A1,4)
Then you could copy column B and paste as values into their required
spot.
Reply With Quote