convert serial date format to normal date format

F

Flagworld

A spreadsheet of mine seems to have chnaged the date format into serial form.
I cannot work out how to chnage it back to dd/mm/yy format
 
R

Rick Rothstein

Format/Cells on the menu bar; Number tab on the dialog box; Custom from the
Category list... type dd/mm/yy into the Type field.
 
S

Stefi

Maybe your date cells format changed to General. Re-format them to the
desired date format (Format>Cells>Number tag>Date category)

Regards,
Stefi

„Flagworld†ezt írta:
 
D

Dave Peterson

If you see that serial number in the formulabar, then I bet you're looking at
formulas:

tools|options|view tab|uncheck formulas
(xl2003 menus)

You can also hit
ctrl-`
(control backquote, the key to the left of the 1/! on my USA keyboard)
 
Top