Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I need to display both date and time in system date and time formats. I know that [$-0xf800] means the system long date format and [$-0xf400] means the system time format, but [$-0xf800][$-0xf400] doesn't work.

What format can I use to display both date and time in system formats?

share|improve this question
    
Please edit your question to include the version of Excel and what OS you are using. Have you tried the options available for cell formatting which automatically adjusts to system formats? – CharlieRB Jan 7 '13 at 12:54

You must log in to answer this question.

Browse other questions tagged .