Saving a Custom Date Format in Excel 2007

Discussion in 'Software' started by fizkowie, Jul 5, 2012.

  1. fizkowie

    fizkowie Private First Class

    Is there a way to save a custom date format in Excel besides saving it in a spreadsheet and using that spreadsheet as a template?

    Thanks.
     
  2. gman863

    gman863 MajorGeek

    Click on the blue "?" (help) button in Excel and type "custom date" as a search term.

    From the results, choose "Create A Custom Number Format". Scroll down and you'll see the options for creating custom date formats.

    Hope this helps. :)
     
  3. fizkowie

    fizkowie Private First Class

    I know how to create a custom date format. However, it is only valid in that spreadsheet. I 'm looking for a way to "keep" if somewhere for use in all spreadsheets?
     
  4. fizkowie

    fizkowie Private First Class

    No takers?
     

MajorGeeks.Com Menu

Downloads All In One Tweaks \ Android \ Anti-Malware \ Anti-Virus \ Appearance \ Backup \ Browsers \ CD\DVD\Blu-Ray \ Covert Ops \ Drive Utilities \ Drivers \ Graphics \ Internet Tools \ Multimedia \ Networking \ Office Tools \ PC Games \ System Tools \ Mac/Apple/Ipad Downloads

Other News: Top Downloads \ News (Tech) \ Off Base (Other Websites News) \ Way Off Base (Offbeat Stories and Pics)

Social: Facebook \ YouTube \ Twitter \ Tumblr \ Pintrest \ RSS Feeds