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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Preserving date format 1
How to enter a date in DD-MM-YYYY format 2
Date format - India/USA 7
Date Format 9
Format Date ComboBox 4
date format 1
Date Format Not Responding to MM/DD/YY 2
Conditional formatting of date-cell - 2007 5

Top