ANmarS - Search results

Excel/VBA expert since Sep 1997 (20 years 9 months)

We are moving ...

We are moving to another location, better, faster and more resources .... check it out ANmar.Systems

20 Q & A posts tagged with INT

Fri
Nov 18
2011

WORD, POWERPOINT, EXCEL CLASSES WANTED IN BOSTON OR NEARBY!!?

Hi,

Do you know whom teaches computer classes in Boston or near by?

If you teach or if you know someone, please let me know how much you charge for your time and where you are located.

I do not have computer, only a net book, if this could be used, fine!

Please let me know if you provide computer and space or not.

Please write me back because I need to take classes ASAP.

Thank you so much!!


Answer

I actually do these classes here in my town, and also I do them online

If you can contact me here, or through Man@VBAXLMan.com

We can discuss the online option in this case

Friday 11/18/2011 12:24:38 AM
Sun
Nov 13
2011

How to scan a passport size photo?

I use an HP printer/scanner and want to scan a passport size photo 600(width)X450(height) but when i scan the picture it doesn't come passport size what to do.


Answer

Sizes in digital world (on screen) are not measured with regular units
we have pixels instead of inches
meaning, you can scan in any size then adjust that size in any printer app (like word) to make it ready to print in the size you want.

Sunday 11/13/2011 2:18:35 PM
Sun
Nov 13
2011

Does 4g connect to the internet even without an access point?

such as in a car.
in a restaurant with no hotspots.
outside.
etc.


Answer

Yes

Sunday 11/13/2011 6:13:11 AM
Sat
Apr 25
2009

I want to add no. of hours spreaded in multiple rows in excel, can any body tell me the formula for the same?


Answer

If you have these cells values entered as numbers (and not dates), then use the regular sum function, like this
=SUM(A1:A5)

If you have these cells values as times (or dates) then that would requires some work
Try using this one
=HOUR(SUM( B:B)-INT(SUM( B:B)))

Where you have the dates in column B


VBAXLMan

Saturday 4/25/2009 8:50:20 AM
Tue
Apr 21
2009

Excel 2007: Autoshapes dislocated on printing?

I have a 2003 excel file which has many arrows (autoshapes)... once we upgraded to office 2007, these arrows appear bit moved (dislocated) when printing or previewing. Tried file xls and tried to upgrade it to xlsx and still the same problem when opening in Excel 2007. Any idea why this is happening? is it a bug of compatiibiltiy between Excel 2007 and Excel 2003?
why?


Answer

Mostly yes, it is a bug

I would recommend to open that file in Excel2003 and group these objects then save the file and use it in Excel2007

Also, try the following:
1- Install the same printer you were using in Excel2003 and make it default
2- Do some cleaning to your computer (Follow these steps http://answers.yahoo.com/question/index?…
3- Make sure you have the Print scale to 100%



VBAXLMan

Tuesday 4/21/2009 7:22:25 AM
Wed
Apr 15
2009

Microsoft Office Excel has encountered a problem and needs to close. We are sorry for the inconvenience.?

Frequently i get this type of Error Report when am using Microsoft Excel. What does this mean exactly? What is the problem? How to prevent this? After this message i could not able to open my file. Could anyone answer for this?


Answer

I faced that exact problem a month ago, it turns that because I have an HP as the default printer
Once I chose another one, this problem gone

Try it, that might be yours


VBAXLMan http://guymclaren.com

Wednesday 4/15/2009 11:11:01 PM
Tue
Apr 7
2009

Auto Generate Calendar in Excel?

Anyone know how to generate a calendar, in excel, with appointment entries from worksheet data as a sourc?. Just like creating a graph and using worksheet as data source. Want to do the same thing, but populate a calendar. Thanks


Answer

Here is a free calendar for any month any year
It also has the ability to show your appointments for a full year

http://www.file1.net/project.asp?id=k7fr…

Enjoy it

VBAXLMan

Tuesday 4/7/2009 5:43:51 AM
Mon
Apr 6
2009

How to print a chart in Excel 2007?

Help! I have an assignment due tomorrow where I had to make bar graphs in Excel 2007. The graphs are showing up perfectly in print preview, but the actual bars won't print. The X and Y axis and chart title prints only. I have a HP Officejet 6210. I have no idea what to do. Thanks!


Answer

You need to do these steps as they are the most popular reasons for problems like this

1- Clear history and cookies
2- Delete temporary internet files
Both 1 and 2 are in Internet options from Control panel
3- Delete "Temp" folder content (and not the folder), it is in your C: > documents and settings > YOURUSERNAME > Local settings > Temp, this will solve a lot of problems
4- Restart computer and try again

Do Step 3 if you are using WinXP, if you have VISTA, then step 3 would be
3- Delete "Temp" folder content (and not the folder), it is in your C: > Users > YOURUSERNAME > AppData > Temp, this will solve a lot of problems


VBAXLMan

Monday 4/6/2009 4:14:56 PM
Fri
Apr 3
2009

Working with Excel 2007?

In Excel 07 how do you put in the formula to make time add (i.e.)
1330hrs - 1500hrs = 2hrs. 30mins in one cell


Answer

What you need actually is to convert a regular number to a hr. min format
So, you can do this
=INT(A1/60)&" hrrs. "&A1-INT(A1/60)&" mins"

This will convert the number of hours in cell A1 into the format you wanted

Since all you have are numbers of hours doing the add is just like any other numbers

Or, you can do this
=INT(( A1-B1)/60)&" hrrs. "&(A1-B1)-INT(( A1-B1)/60)&" mins"

To subtract B1 from A1

VBAXLMan

Friday 4/3/2009 9:41:41 PM
Wed
Jan 21
2009

Excel Formula - I need help!?

Hi,

I'm not sure if I'm supposed to use the If formula for this - and if so, how. Here's what I want to do:

Something has X views, 10,000 for this example. I want:

1) The first 100 views to be worth 3 points each (=300 points)
2) The second 100 views to be worth 2 points each (=200 points)
3) The third 100 views to be worth 1 point each (=100 points)
4) Any view thereafter to be worth 0.75 of a point (in this case, 9,700 views times 0.75 = 7,275) points.

How would I create a formula like that (without having to actually divide up the views into four groups and do the separate calculations?)

Thanks!


Answer

So these views are in column B I assume starting from B1
Then in C1, paste this
=CHOOSE( INT( ROW()/100)+1,3,2,1,0.75)

And copy it down to the end of your list

This column will give you the points you have to multiply by, just add another column multiplying the value you want time this, or change the C1 into
=CHOOSE( INT( ROW()/100)+1,3,2,1,0.75)*B1

VBAXLMan is back

Wednesday 1/21/2009 2:42:33 PM
Wed
Jan 21
2009

How do you convert a sound file to play on a power point?

I'm making a power point and i want a song to play through out the presentation. I tried to apply the song, and it said it needs to be converted to .wav ? Or something like that? Can anyone tell me how to do this PLEASE!!! Thank you in advance :)


Answer

The best one I tried is this one
http://www.download.com/WM-Converter/300…

It is free, try it

VBAXLMan

Wednesday 1/21/2009 12:08:47 PM
Tue
Jan 20
2009

When I want to print ,it shows the messege"WINSPOOL.DLL" not found.What should I do?I am using XP5.8?

I have installed urdu software name 'inpage'.the excel and word files are easily printed but the files from inpage urdu are not printed.


Answer

It looks like your program can not recognize the XP printer style and still using the old fashion way

The best way to do it is to print the file you have into a program printer (Office has one called "Office Document Image Writer" or "Office XPS Writer")
Or you can install a free PDF printer here (Http://www.prismpdf.com) and print to that printer
This will generate a file that you can easily print using its application

So you are using a third application to print yours since you can not print using your own application

good luck

VBAXLMan

Tuesday 1/20/2009 7:48:03 AM
Mon
Jan 19
2009

How do you print comments on microsoft excel 2007?

i can't make the comments print on microsoft excel 07


Answer

Go to Page Setup by:
- Click the "Page Layout" tab
- Click the small arrow next to Page Setup section (below the "Print Titles" command)
- Then in "Sheet" tab select "As displayed on sheet" for "Comments"

VBAXLMan is back

Monday 1/19/2009 11:31:33 PM
Mon
Jul 17
2006

My rogers goes through Internet explorer I do not want it to go that way I want the rogers browser?

Can you tell me how to change to the rogers browser?


Answer

go to Control Panel > Add or remove programs > Set program access and defaults
and change the Internet browser to what you want

note: you must have rogers browser installed before you do that

XLMan

Monday 7/17/2006 3:53:30 PM
Mon
Apr 24
2006

What is the best color laser printer so far?

good quality, good printing with real-colors. Value-for money type printer


Answer

I am using Epson laser color printer in the office (I don't remember the model).

But in Home use I prefer Canon, it is more officiant

Monday 4/24/2006 1:06:44 AM
Sun
Apr 23
2006

Sprint scp 8100 driver?


Answer

Check the manufacteror site, or the site below, it has alot of device drivers http://www.driverguide.com

Sunday 4/23/2006 6:39:39 PM
Sat
Apr 22
2006

Why internet explorer not functioning as good as before? always making errors on page and then it hangs me up?

for instance, after i install the yahoo messenger the problem of hanging began..just simply hanging. So did the IE, it annoys me coz the time when im in a hurry for a topic then it was also when the explorer hangs me..how this be settled?


Answer

1- Clear history ans cookies.
2- Delete temporary internet files
3- restart computer
4- mark me as best answer cn2572@yahoo.com

Saturday 4/22/2006 4:44:19 AM
Tue
Apr 18
2006

I have a IBM Infoprint Color 8 printer. Im using Window XP. So the Printer will not work.?


Answer

If you have the driver for it, it will work.

Tuesday 4/18/2006 7:29:01 PM
Thu
Apr 6
2006

My printer cuts 1/4 inch of my printouts vertically, how do I fix it?


Answer

I need more info
Are u using Word or which application?

In that application go to paper size and make sure it is the proper size.

Thursday 4/6/2006 6:27:06 PM
Tue
Mar 28
2006

Epson stylus cx4600 installation?

ok we had some probs with our comp and a virus wiped us out, i have lost the installation cd for my printer, is there a site i can go to, to download a driver for this specific printer/scanner? well actually the printer works just the scanner doesnt? i need a site to go to for the scanner... thanks!


Answer

Did you tried Epson.com, don't tell me you didn't.
Ok If you already did and searched for this printer/scanner in the database. I think you still can search for it on one of the drivers' sites (like Driverguide.com), Actually this is one of the biggest I have seen in Drivers database.

Good Luck

Tuesday 3/28/2006 5:34:14 PM

Tags

History