+ Reply to Thread
Results 1 to 4 of 4

Can't view date

  1. 04-30-2009, 05:33 AM #1
    Little Master
    Little Master is offline
    Forum Contributor
    Join Date
    10-20-2005
    Posts
    130

    Can't view date

    Hello again people, i was doing something in Tools -> Options -> View, & suddenly the dates in my sheet disappeared & some numbers came up, i can view the date in the formula bar, but can't be viewed in the cell, & i am also unable to do the alignment for the cell..... pls help



    Thanks in advance....
    Last edited by Little Master; 04-30-2009 at 05:58 AM.
    Regards,
    Little Master
    Reply With QuoteRegister To Reply
  2. 04-30-2009, 05:38 AM #2
    Andy Pope
    Andy Pope is offline
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,481

    Re: Can't view date

    Check
    Tools > Options > View > Formulas
    Cheers
    Andy
    www.andypope.info
    Reply With QuoteRegister To Reply
  3. 04-30-2009, 05:41 AM #3
    Little Master
    Little Master is offline
    Forum Contributor
    Join Date
    10-20-2005
    Posts
    130

    Re: Can't view date

    Quote Originally Posted by Andy Pope View Post
    Check
    Tools > Options > View > Formulas
    Thnx andy it worked..... thnx.....
    Last edited by Little Master; 04-30-2009 at 05:49 AM.
    Reply With QuoteRegister To Reply
  4. 04-30-2009, 06:06 AM #4
    broro183
    broro183 is offline
    Forum Expert
    Join Date
    01-03-2006
    Location
    Waikato, New Zealand
    MS-Off Ver
    2010 @ work & 2007 @ home
    Posts
    2,243

    Re: Can't view date

    This setting can be accidently (or intentionally) toggled to...

    Excel 2007 Help files: Switch between displaying formulas and their values on a worksheet
    Press CTRL + ` (grave accent).
    hth
    Rob
    Rob Brockett
    Kiwi in the UK
    Always learning & the best way to learn is to experience...
    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)

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