Donate SIGN UP

Effing Excel! Help pls

Avatar Image
evedawn | 11:17 Mon 30th Aug 2010 | Technology
18 Answers
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)
Gravatar

Answers

1 to 18 of 18rss feed

Best Answer

No best answer has yet been selected by evedawn. Once a best answer has been selected, it will be shown here.

For more on marking an answer as the "Best Answer", please visit our FAQ.
Click on the cells...go to Format.......Cells............Number.........
..and
choose decimal places required in dropdown
Format columns.
or if you already have cells with the correct format use the paintbrush icon to make your new cells the same...
Question Author
thank you thank you thank you !!!!! (I'll mention again that I hate excel)
Do you use the paintbrush....it's excellent.
Question Author
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!!!!)
Excel is really easy. When you've mastered it you'll think anyone who can't is a bit dumb...
The Format Painter is the yellow brush symbol. Usually beside the Cut, Copy + Paste icons
Not calling you dumb btw....
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.
I'm dumb. I don't get excel at all yet photoshop is 2nd nature, even though apparently that's hard too.
Everything is hard until you know how to do it...
Very true Ummmmm
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.
Question Author
Thanks everyone - keep the encouragement going please! I need it. PS:....I hate effing excel with every fibre of my being!!!!!
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.
This guy's workbooks were amazing beso. He used to build model networks on them and fire different data at them for test purposes.
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.

1 to 18 of 18rss feed

Do you know the answer?

Effing Excel! Help pls

Answer Question >>

Related Questions

Sorry, we can't find any related questions. Try using the search bar at the top of the page to search for some keywords, or choose a topic and submit your own question.