Thanks For the Help
Thanks for taking the time to reply. Have a great day!
Eddie
Thanks For the Help
Thanks for taking the time to reply. Have a great day!
Eddie
I have a sentence in field A1 and a number in field A2. The formula I am using is =A1 & A2. This is working but there is no space in between A1 and A2. How can I add a space? Thanks in advance.
Re: Adding Data
I will give it a shot. Sounds simple. I am not familiar with VBA but I will Google it. Thanks
Eddie
How does one add data to a field that has existing data? For example, say I have a list of different people names and want to say the word "visitor" at the end of each name how is that done for an entire list without have to do it one by one. Also how do I add a word to the beginning of a list of names as well? ANy help is appreciated. Please make it simple, as I am an average user. Just basic spreadsheets that add and multiply.
Eddie
PS: I am using Excel 2003.
Re: Formula Error
Thanks. That worked. How do you think it got uninstalled?
I am using this formula in an Excel worksheet. The formula is "=workday(K41,2)", which was giving me the date in field K41 plus 2 days. Now instead of the date I get "#NAME?". Anyone have an idea what went wrong?
Thanks
Eddie
Re: Page Number
that was easy. knowledge is power. have a good day!
thanks
Eddie
I was sent an excel file and each page has in big font Page 1, Page 2, and so on. My question is: how do I remove these "Page numbers". Thanks
Eddie
Re: Amortization
That wasn't what I was looking for, but thanks. I found what I was looking for. This is the formula for calculating the payment on a mortgage by using the principal, interest rate and term of loan. Formula:
=-ROUND(PMT(F2/12,F3*12,F1),2)
The monthly payment on a $40,440.21 loan at 3 percent for 20 years is $224.28.
Thanks
Can someone explain how to amortize a loan using excel. I currently use excel for all my work, but have been using lotus for amortizations because it's a template that one uses where you just plug in the amounts and interest and years. I want to get away from lotus completely and use Excel for everything.
thanks
When I click on the borders drop down box I only have solid lines. Is there a way to add dashed lines to this box. I know you can right click , format cells and do it that way, but that is more steps than i would like to use. If I could add it to the drop down box that would be great.
thanks
Eddie
Re: Percentages
Your second formula worked.
Thanks
Eddie
Re: Percentages
This is what i entered:
=IF(ISBLANK(C3),"",B3/C3)
I am not getting the ###, but I am getting "#DIV/0!". Did I do something wrong?
Thanks
Eddie
I have a file that has a percentage formula. since i dont have any numbers in the some the cells i am getting ### in the formula cell. How can I have excel not display anything there?
thanks
Eddie
Re: Copy and paste special
Thanks, it worked
Eddie
I have 2 excel files. One links to the other. It is a payable spreadsheet. Sometimes I have 1 item listed on file one, sometimes it's more than 3. I did a copy and paste special link from file 1 to file 2. The thing is than when I only have 1 item on file 1, file two will show a "0" when I don't have any data on file 1 to link to file 2. How can I eliminata the "0" from showing when I have no data on file one? Hope I made sense.
Thanks
Eddie
I have a wordperfect file that has pictures in it. When I tried opening this file in word only the font was visible. Is there a way to get the pictures to open in word. I tried to copy the pictures in the WP file and paste them to Word, but it didn't work. Anyone have any idea on how I can get this to work?
thanks
Eddie
Re: Date
Thanks For The Help.
Eddie
Re: Date
WHat I meant to say what instead of the month being February I would like it to be FEBRUARY. I want all the letters capitalized. Sorry for the mix up.
thanks
Eddie
I have an excel worksheet where the current date is automatically inserted. What I would like to know is, how do I get Excel to capitalize the month automatically as well?
thanks in advance,
Eddie