+ Reply to Thread
Results 1 to 2 of 2

Date change to number

  1. 02-09-2010, 07:18 AM #1
    minkey050705
    minkey050705 is offline
    Registered User
    Join Date
    02-09-2010
    Location
    Madrid,Spain
    MS-Off Ver
    Excel 2007
    Posts
    1

    Unhappy Date change to number

    Hello Everybody,

    For a while now I have a had a problem with Excel changing all the dates to numbers. I have tried to change the format, but to no avail. When I select a field with a date the navegation bara shows the date, but the appearance in the page is of a number. Anyone know how to get the dates back or why this has happened?

    Many thanks.
    Reply With QuoteRegister To Reply
  2. 02-09-2010, 07:34 AM #2
    teylyn
    teylyn is offline
    Forum Expert teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,372

    Re: Date change to number

    hello minkey,

    welcome to the forum.
    I have tried to change the format, but to no avail
    How does that manifest? What happens when you assign a date format to the cell?
    Microsoft MVP
    http://www.teylyn.com
    Twitter: http://twitter.com/IngeborgNZ
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1