Excel Basics #12: Stylistic & Number Formatting

Have a column that contains something I can't see. It's causing that entire
column to register when exporting to a different database. I can't find the
culprit - am guessing it's a tab or a line break that's in one of the cells.
In Word, I can view formatting marks. Is there a way to view those in Excel
so that I might find this rogue entry in a cell?

i want to make a cell red if the formula's value does not equal another cell. What is the formula?

Thanks, Howie

I admit I am lost. I want to do apparently simple thing but somehow it never works...I must be highlighting wrong or doing something out of order etc.

I have a pivot table. Imagine it showing Dept date anc charge...like this:

Dept Date Charge
51 1/1/09 20.00
1/2/09 10.00
2/26/09 10.00
3/6/09 20.00

55 1/1/09 20.00
1/2/09 10.00
2/26/09 10.00
3/6/09 20.00


etc etc I HOPE I DID NOT LOOSE THE FORMATTING!

Anyway I want the first line (the one that shows the dept) BOLDED. I thought I could do dhtis with conditional formatting, applying it the sheett all at once by saying if the value in row A > 0 then bold the line..........but I am not doing right...HOW WOULD YOU DO THIS?

I have a spreadsheet that shows a date, because of shipping I need to enter a
date and then calculate three months back and enter that date, For example
Cell A1 March, 2004 and I have to enter into cell B1 January 2004, how do I
get Excel to do this automatically.

Please can anyone help me answer any of these questions:

How would you add the contents of the cells from A1 to A10. Give 2 ways
to do this. (hint: Look up "Examples of common formulas" in Excel
help



How do you format a cell to have dollar signs next to the numbers?



How do you add the contents of cells A1 through A10 on sheet 1 and make
the answer show up on sheet 2?



How do you rename a sheet?



Can I delete the sheets that I don't need? If so how?



How do I freeze rows or columns of the sheet so that they don't'
move when you scroll up or down? Example: My name is in Column A, when
I scroll right my mane stays on the screen and column B moves behind A



How do you add up all the contents of column D and make the answer show
up in column C?


Thanks in advance!
abi

I went to the website cpearson.com and got the information for the syntax and the formula to sum numbers in different colors on a worksheet
now my problem is where do i put the visual basic part of the works so the formula can call on it
can you tell i have no idea but great hopes!!!
thanks everyone

Basicly the same as the title.. I want to learn more about excel... I consider myself to be just a bit better then a noob, i can use the sum function, and i think i understand how most easy things work

I'm trying to populate a Word 2003 document with data from an Excel 2003 document -- I realize some use mail merge but this, for me, has been an excruciating pain in the neck, so I am trying to avoid it by going the Word bookmark route, which looks like it will fit the bill... if only I could figure it out!

I have done some searches on here and this is the code that seems to have set the precedent:

http://www.mrexcel.com/forum/showthread.php?t=478182

However, as a beginner, it's a bit overwhelming for me. While I'm learning a lot by looking at it and looking up the things I don't understand, it's taking a long time and I actually need to use something similar for my own project.

Specifically, I wanted to open a template letter; populate it from the active Excel row I'm working on; and then "Save As" so I can keep the template.

Is there some more generalized information out there that outlines this procedure? Otherwise, would someone be kind enough to separate the code and/or elaborate more on what the invididual lines/sections do?

Hope you can help!

Alright i'm using Excel 2007, i created a table with 2 columns and 5 rows
cell A1 - A5 has a list of numbers, and Cells B1 - B5 has a list of food items,

I've created a blank User-Interface form, using VisualBasics which came inside excel 2007, how do i get the table in my Excel Sheet, to show as it is with it's color coding and grid lines in the VisualBasics Form,


My second question is, I also created a Seperate Visual Basics form in Visual Basics 2008, could i get the table in the Excel form, to show in the form in Visual Basics 2008 programme, I have no clue how to link Visual basics, to Excel so a non-overly technical step-by-step guide would be extremely appreciated,


Thank you,

Hello,

I'm using Excel 2003 and Windows XP SP2.

I am not using any special formulas and I have not altered any formatting.

I use a single workbook with about 25 worksheets in it.

Suddenly, when I enter a plain round number, Excel enters it as a decimal point.

Example: I enter a round number like 5 and it enters it as .05

I try to enter a round number again in the next row, same column and unless I enter a round number and a period, it enters the round number as a decimal point again.

I have to keep entering a period just to get my whole number to appear.

I tried to fix this by selecting the number format, the text format and even the general format, one at a time, and the same problem exists.

Some of the worksheets in this same workbook allow round numbers to be entered correctly and some don't.

This was from Excel 2003's help and this is what I've been using all along:

Number: This format is used for the general display of numbers. You can specify the number of decimal places that you want to use, whether you want to use a thousands separator, and how you want to display negative numbers.

I appreciate the help especially considering this would be the least of anyone's problems here!