| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
date in wrong format
My mo/da/yr format somehow changes to a 5 digit entry - 393xx. I have tied
the normal procedure of format cells, date, etc. but that won't fix it. What can I do? |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
date in wrong format
Mike this is a little long winded but I found it helpful in resolving many a
format problem: http://support.microsoft.com/default...;en-us;Q264372 "Mike" wrote: My mo/da/yr format somehow changes to a 5 digit entry - 393xx. I have tied the normal procedure of format cells, date, etc. but that won't fix it. What can I do? |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
date in wrong format
You should also be able to type 1 into a cell, copy it and paste special on
top of your dates - Multiply. Should force format to what you want. "Mike" wrote: My mo/da/yr format somehow changes to a 5 digit entry - 393xx. I have tied the normal procedure of format cells, date, etc. but that won't fix it. What can I do? |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
date in wrong format
That entry looks like its the date serial number, how are you formatting your cells? -- The Code Cage Team Regards, The Code Cage Team http://www.thecodecage.com ------------------------------------------------------------------------ The Code Cage Team's Profile: http://www.thecodecage.com/forumz/member.php?userid=2 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=29747 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Cell Format - What's wrong? | Excel Worksheet Functions | |||
| Date in wrong format | Excel Discussion (Misc queries) | |||
| Wrong date format in header | Excel Discussion (Misc queries) | |||
| date entered wrong or not as a date | Excel Worksheet Functions | |||
| YYYY format displaying wrong date | Excel Discussion (Misc queries) | |||
Linear Mode
