I want all the birthdates to be in the form dd/mm/yyyy but the data was
imported into the spreadsheet in the form yyyy-mm-dd. I've gone into the
cell format menu and changed the format to the one I require but the cells
refuse to update to the new format. The only way I have managed to get them
to change is by putting the cursor in the cell and hitting return. When I do
this the cell refreshes to the correct formatting. The thing is, I have a
data base with hundreds of dates in it, and I'm getting bored with having to
click into each cell to make it change to the new formatting.
--
Michelle