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

VBA - exporting serial letters to single documents 0
How to use/create code in MS Word to calculate age? 0
How to enter a date in DD-MM-YYYY format 2
Excel does not accept text format! 0
How to add day to PWA 2016 date format? 0
Date Formats 4
Preserving date format 1
How to change the date format from import link? 1

Top