Backyard Adventures Garage

Friday, January 25, 2013

APFT Calculator

Action Stations Action Stations, Set Condition One Throughout the Ship, This is Not a Drill

Thursday, November 15, 2012

Grill for Ford F250 2004 Super Duty 6.0 Lariet

Grill for Ford F250 2004 Super Duty 6.0 Lariet

Saturday, December 10, 2011

Top 10 Inconvenient Truths about Global Warming

Tuesday, June 21, 2011

Media Monkey Manual

Media Monkey Manual:

Tuesday, June 7, 2011

Duplicate File Remover
Print out MP3 lists

Tuesday, March 22, 2011

Excel changes my cells to Date from General

Dear All:
I've had this happen four times now on different machines at different times.

Excel 2007 when opening a Shared Workbook and changes all general formatted
cells on all sheets of the workbook to Date Format {mm/dd/yyyy}.

Changing the format back to general only means they again default to date at
the next opening, you must format to text or number to prevent the auto date
format application.

Here is how you fix it:

You have to modify the Normal Style.  This has been driving me crazy.  See below:

In Excel 2007 you can click on the 'Cell Styles' option on the menu bar. Then right Click on 'Normal' in the top left hand corner of the displayed styles and then select the 'Modify' option. you will see that the number format is set to date and time.

Select the format... button and then select whichever format you want for general numbers, e.g. two decimal places and red for negative. Click on 'Ok' and you should see that the format in the dialogue box has been reset to '0.00;[Red]0.00'. Click on OK, and then save the spreadsheet. You should find that all cells now default to this format for numbers rather than Date/Time.

Tuesday, March 1, 2011

Ammunition 67