reformat dates to yyyy/mm/dd
My concern is the data being uploaded into a database, even though the format
looks like yyyy/mm/dd, the cell value is still mm/dd/yyyy. Will it read the
data the way IT says it should be (yyyy/mm/dd)
"Dave Peterson" wrote:
If the values are really dates, you could just select the range and change the
format to what you want.
Katerinia wrote:
I have a worksheet with dates of mm/dd/yyyy
I need to reformat them now to be yyyy/mm/dd
Whats the formula for that?
--
Dave Peterson
.
|