LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default In Excell, how do I change the date from 39443 to 12/27/08?

One page in Excell 2005 suddenly started putting all the dates just numbers,
such as 39443. I can copy a cell with a number and paste it into another
cell in another page and it will display the correct date. I've tried
formatting the cells but nothing I've tried will work.
 
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
Why do column widths change in Excell? JPEgan Excel Worksheet Functions 1 January 13th 07 07:08 PM
How do I change the date format in Excell from eg 20060926 Dave Excel Discussion (Misc queries) 2 September 30th 06 02:22 PM
How do I change excell doc to all caps? princechopper Excel Discussion (Misc queries) 2 July 15th 05 12:31 AM
the scroll wheel goes across in excell how do i change this Karline Excel Discussion (Misc queries) 2 May 11th 05 11:08 AM
I cannot get excell to change to landscape James Limey Excel Discussion (Misc queries) 1 March 21st 05 09:29 PM


All times are GMT +1. The time now is 01:37 PM.

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

About Us

"It's about Microsoft Excel"