Effing Excel! Help pls

[evedawn]

As many of you know I am trying to teach myself Excel!!! Now I am working on a spreadsheet and needed to add three rows (easy!) but one of these columns needs to have some numbers (eg: "1") when I insert the number it automatically defaults to decimal (ie 0.01) i have TRIED just decreasing th decimal via the decimal function on the toolbar but it doesn't help. PS all the other rows in that column DONT default. Why (PS I am beginning to *&(*&(&*(*&!!!!! hate this *&&(&&£^£!!!!!!! - insert swearwords of your choice)

[craft1948]

Click on the cells...go to Format.......Cells............Number.........
..and
choose decimal places required in dropdown

[kawakiri]

Format columns.

[craft1948]

or if you already have cells with the correct format use the paintbrush icon to make your new cells the same...

[evedawn]

thank you thank you thank you !!!!! (I'll mention again that I hate excel)

[craft1948]

Do you use the paintbrush....it's excellent.

[evedawn]

This is Excel Is the "paintbrush" the "thin" black cross that copies formulas?
(I'll tell Y'all again...I hate effing excel...with a passion!!!!)

[ummmm]

Excel is really easy. When you've mastered it you'll think anyone who can't is a bit dumb...

[scotman]

The Format Painter is the yellow brush symbol. Usually beside the Cut, Copy + Paste icons

[ummmm]

Not calling you dumb btw....

[craft1948]

No it is a picture of a little paintbrush on the toolbar. If you insert new cells, or rows, or columns and want to copy formats all you need to do is highlight the cells etc which are formatted correctly, click on the paintbrush icon, then click on the new cells, and it will copy your formatting across.

[Mojo-Jo-Jo]

I'm dumb. I don't get excel at all yet photoshop is 2nd nature, even though apparently that's hard too.

[ummmm]

Everything is hard until you know how to do it...

[Mojo-Jo-Jo]

Very true Ummmmm

[craft1948]

I once worked with this guy who was borderline genius, he had a first class degree in electronic engineering, and used excel when designing telecomms networks. He reckoned excel was brilliant, but most people only used 10% of the software's capabilities.

[evedawn]

Thanks everyone - keep the encouragement going please! I need it. PS:....I hate effing excel with every fibre of my being!!!!!

[beso]

Most people only using ten percent would be generous. Excel has limitless capacity with its VBA programming language allowing it to even control other programs and the Windows operating systems itself.

I have Excel spreadsheets that don't look like spreadsheets at all but rather more like programs that can connect to databases, read and parse electronic documents to generate spreadsheets automatically.

[craft1948]

This guy's workbooks were amazing beso. He used to build model networks on them and fire different data at them for test purposes.

[TTG]

There are plenty of online resources and free tutorials. Also the help facility in Excel is very good. Usually answers questions with a text and graphical example.