National Homebrew Club Ireland

General Discussions => Chit Chat => Topic started by: Will_D on July 11, 2014, 02:08:49 PM

Title: Spreadsheet Help
Post by: Will_D on July 11, 2014, 02:08:49 PM
I know we have some great Excel users here so a question:

Somehow, now whenever I create a new worksheet all the cells default to a currency format.

This is amajor pain the butt!

I cannot find out how to change this to say a general format!

Help
Title: Re: Spreadsheet Help
Post by: wilted on July 11, 2014, 02:17:42 PM
Create a template - So a blank workbook with everything set the way you want. File - save as an xltx excel template named book
Copy that into C\:Program Files\Microsoft Office\Office14\XLSTART for excel 2010 and every workbook sheet you use should use that template from now on.
Title: Re: Spreadsheet Help
Post by: Will_D on July 11, 2014, 08:29:42 PM
Cheers wilted - I will certainly try that.

BTW Welcome to the NHC - where are you based?
Title: Re: Spreadsheet Help
Post by: wilted on July 11, 2014, 08:36:13 PM
Thanks, I've been lurking for ages ;) hiding out in north Dublin
Title: Re: Spreadsheet Help
Post by: nigel_c on July 11, 2014, 08:38:44 PM
Get Him Will. Get HIM !!
Title: Re: Spreadsheet Help
Post by: Will_D on July 11, 2014, 11:32:32 PM
May we welcome you to our humble group:

http://www.nationalhomebrewclub.com/forum/index.php?board=23.0 (http://www.nationalhomebrewclub.com/forum/index.php?board=23.0)

We meet up in the Old Boro in Swords every 2nd Tuesday of the month.

We ARE the best, most consistent, most organised group in the NHC!

Looking forward to meeting up!

Will
Title: Re: Spreadsheet Help
Post by: brenmurph on July 12, 2014, 12:33:03 AM
"We ARE the best, most consistent, most organised group in the NHC!"

eh careful.....wit ur unsubstantiated claims.... ;D

@ wilted...dere allright dem northsiders albeit a little cocky....been dere a few times so go for it and meet them up...but if u ever get a chance to come to  the best, most consistent, most organised group in the NHC hop on the green bus at the airport and get off at junction 13 / M7.. :) ;) :D ;D :P