Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default convert serial date format to normal date format

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
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 5,934
Default convert serial date format to normal date format

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.

--
Rick (MVP - Excel)


"Flagworld" wrote in message
...
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


  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,646
Default convert serial date format to normal date format

Maybe your date cells format changed to General. Re-format them to the
desired date format (FormatCellsNumber tagDate category)

Regards,
Stefi

€˛Flagworld€¯ ezt Ć*rta:

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

  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default convert serial date format to normal date format

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)

Flagworld wrote:

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


--

Dave Peterson
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I change the serial date to a dd/mm/yyyy format minkypuss Excel Discussion (Misc queries) 4 September 22nd 08 10:49 PM
Convert date from text format to date format Anita Excel Discussion (Misc queries) 3 June 4th 07 11:57 AM
Convert date + time text format to date format Paul Ho Excel Worksheet Functions 2 May 22nd 07 05:47 PM
Format serial date and time Cedric Excel Discussion (Misc queries) 2 December 26th 05 10:06 PM
Convert SERIAL date back into dd/mm/yy format? Aussie CPA Excel Worksheet Functions 6 September 30th 05 02:05 AM


All times are GMT +1. The time now is 10:48 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"