View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Katerinia Katerinia is offline
external usenet poster
 
Posts: 22
Default 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
.