Question about Microsoft Office Standard for PC

1 Answer

Roundding In default system round any number based on 5 but I want to change this number according to my requirement as like 6 or 7 whatever, then how will it possible. e.g., Fixed No. 6 When my nos. 1 to 5 then no. rounded to 6 otherwise 1

Posted by on

1 Answer

  • Level 2:

    An expert who has achieved level 2 by getting 100 points


    An expert that got 5 achievements.


    An expert who has written 3 tips or uploaded 2 video tips.


    An expert whose answer got voted for 20 times.

  • Expert
  • 112 Answers
Re: Roundding

Suppose your Figure is in Column A1, simply write: round(A1/6)

Posted on Sep 06, 2007

Add Your Answer

0 characters

Uploading: 0%


Complete. Click "Add" to insert your video. Add


3 Points

Related Questions:

2 Answers

System requirement to run crystal report v9 professional

System Requirements

  • PC with AMD or Intel based processors, Dual Core CPU, 2 GB RAM.
  • 3.5GB available hard drive space (for English only, 7.5 GB for all languages)
  • DVD drive (for DVD install only)
  • Microsoft Windows 7 SP1, Windows 8, Windows Server 2008 SP2, Windows Server 2008 R2 SP1, Windows Server 2012
  • Languages: Chinese simplified, Chinese traditional, Czech, Danish, Dutch, English, Finnish, French, German, Hungarian, Italian, Japanese, Korean, Norwegian, Polish, Portuguese, Romanian, Russian, Slovakian, Slovenian, Spanish, Swedish, Thai, Turkish

Technical Specs

  • Hardware Requirements: Intel Pentium III or equivalent processor, 256 MB RAM, 512 MB Recommended
  • Disk Space: 2 GB for default installation with English language, 4 GB for default installation with all languages installed

Dec 23, 2013 | Crystal Decisions Crystal Reports V9...

1 Answer

'Print error #5'

MYOB requires that you have a default printer selected on your computer system. If no printer driver is installed, when opening a company file, a printer error #5 is displayed.

Highlight your Printer and go to File on then Menu bar/Set as default.and Turn off user account control if you're using vista. It's in your security center in the control panel. Turning this off should fix the printer error 5 issue .

Mar 03, 2010 | Myob Accounting Plus (BPJUBC00) for PC,...

1 Answer

MS office documents opening very slow

Hi friend,

Firstly remove all the temp and recent documents in your system,these are the most resion for slow response ,these file location are
My computer -> c drive -> choose your profile
* Delete all contents of My recent documents & templates
* open local setting option and delete all temp and Tempapory internetfiles
* Go to application data -> microsoft -> office -> and clear the all files in under recent folder.

close the window.

2nd step is change the registory setting.for registory setting follw the given instructions
1- click the start button and go to option Run
2- type regedit and than press ok
3- one window show in front of you,choose option according thses instructions
HKEY_CURRENT _USER---->softwar ------->microsoft----------> office --------> 11.0 -------> comman-----------> choose the open find option
4-click the right side window of open find
5-Right click and choose New ----> DWORD value
6-one ?New value icon show in the window
7-right click the new value and choose reanme option
8-put the name EnableShellDataCaching
9-Name has been chnaged of new value and right click of EnableShellDataCaching and choose modify
10-put the value 1 inplace of 1
11-exit the registory wondow

and 3rd step is update youe system window by using given below microsoft link

than restart ths system and than you see the take effect in your Ms office related application's


Feb 11, 2010 | Microsoft Office Publisher 2007 for PC

2 Answers

Hyplinks do not work in Outlook 2007. they used to work, not sure what made them stop

Fix 1: Start by Resetting Your Default Browser Most times, I can fix my Outlook hyperlink problem by resetting my default browser to Internet Explorer. I start with this step even if I plan to use Firefox as my browser. The reason I choose this path is I’ve had better success and it takes me closer to my end goal.
To make IE your default browser,
1. Open Internet Explorer
2. Click Tools from the menu
3. Select Internet Options.
4. Click the Programs tab
5. Click the button labeled Make Default.
6. Click OK.
7. Test a hyperlink in Outlook to see if the web page opens in Internet Explorer.
Fix 2: Reregister Windows DLL Files Even after resetting your default browser you still can’t open hyperlink in Outlook, it could be one or more registry keys is damaged. The solution is to reregister some of your DLL files. The process may sound intimidating, but it’s easy. There are 6 files to register based on your system. Some configurations use shdocvw.dll and others use shdoc401.dll.
To reregister the DLL files,
1. Close all open programs.
2. Click the Start button.
3. Select the Run… command. Vista users can type “run” in the Start Search textbox.
4. In the Open: textbox, type regsvr32 followed by a space and the file name.
In the screen snap below, I’ve used the first file Shdocvw.dll.
5. Click the OK button. You should see a message showing the process succeeded.
6. Click OK to dismiss the message.
7. Repeat the procedure for the other DLL files.
  • regsvr32 Shdocvw.dll (Some system use Shdoc401.dll instead)
  • regsvr32 Oleaut32.dll
  • regsvr32 Actxprxy.dll
  • regsvr32 Mshtml.dll
  • regsvr32 Urlmon.dll
  • regsvr32 Shell32.dll
8. As before, test to see if your Outlook hyperlink problem has been resolved.
Fix 3: Reset the (NONE) URL File Types If you’ve gotten to this part, I have to figure your Outlook hyperlinks are still broken. Don’t fret as I have another fix to try. My guess is someplace along the line your file associations broke. This is the mapping Windows uses to a file type to program. A common mapping might be .XLS files with Microsoft Excel. In this case, we need to check URL mappings.
To set URL file associations,
1. Open My Computer.
2. From the Tools menu, select Folder Options…
3. Click the File Types tab. A long list of Extensions and File Types appears.
4. Scroll down till you get to (NONE) URL:HyperText Transfer Protocol
5. Click the Advanced button.
6. Select the bold open item. *
7. Click Edit…
8. Click the Browse… button
9. Navigate to where Internet Explorer is located. (For most PC, it’s at C:\Program Files\Internet Explorer\iexplore.exe)
10. Add a space and %1 to the end of the file name. (e.g. "C:\Program Files\Internet Explorer\iexplore.exe" %1)
11. Click OK.
12. Click Close.
13. Repeat the process for (NONE) URL:HyperText Transfer Protocol with Privacy.
* If open doesn’t show, click New and type open in the action box.
Back to Firefox (Optional) Once you get the Outlook links to open in Internet Explorer, you can change your default browser to Firefox. This should roll down to Outlook so any embedded hyperlinks will open in the correct browser.
To set Firefox 3 as your default browser,
1. Open Firefox
2. Select Tools from the menu
3. Select Options…
4. Click Advanced
5. Click the Check Now button
6. Click Yes if the default browser is not set.
7. Click OK.

Nov 20, 2009 | Microsoft Office Professional 2007 Full...

3 Answers

How to round the fig. in Excel 2007 E.g. 12350*32.75% = 4044.625 I want it to be rounded to nearer rupee. If the decimal is lesser than 50, rounded fig. should be lower Rupee if the decimal is more than 50...

The function is called ROUND. It has 2 arguments, (1) the original number and (2) the number of decimal digits. Here is the Excel's help: ROUND(number,num_digits) The number you want to round. None. num_digits The number of digits to which you want to round number. If num_digits is greater than 0 (zero), then number is rounded to the specified number of decimal places. If num_digits is 0, then number is rounded to the nearest integer. If num_digits is less than 0, then number is rounded to the left of the decimal point.
So for your case use this in a cell "=ROUND(12350*32.75%, 0)" without quotes, where I assume one or both numbers will come from other cells. -Ken

Aug 29, 2009 | Microsoft Office Excel 2007

2 Answers

Cannot recognize working microphone

I found the answer. Rosetta Stone has a problem detecting the mics if the speaker input is not in someway connected to the mic. I'm not exactly sure how it works, but I don't care and neither should you.

Follow these steps each time you want to use it and you should be fine.
*I'm on Vista, but this should work for every one.
1. Open Control Panel
2. Open Hardware and Sound
3.Open Sound
4.Set Line 1 as your Default Speaker
5. Refresh the Mic list
*All of your mics should now show up.
6. In Rosetta Stone, apply the mic you want and finish the setup.
7.Start whatever language you're using and switch back to the Sound menu.
8.Set whatever speaker you want to use as default.
*Rosetta Stone will continue to work fine until you close it, switch Users, or remove the mic.

In short you have to set the default speaker to LINE 1 to get the mics to appear. Then when you apply the settings switch the default speaker back.

Apr 21, 2009 | Business & Productivity Software

1 Answer

Random number generation.

you can use the Round function as below - it rounds out the decimal to 0 places, which gives you 5 digits with no commas


Jul 10, 2008 | Microsoft Excel for PC

3 Answers

Excel Formula

columns total in additin cells of rows equal are total

Oct 24, 2007 | Oracle 10g Database Standard (ODBSEONUPP0)

1 Answer


suppose ur number is at cell B2 with any value. lets say u want formula in A3. then A3 =*b2*3/4 to round back the A3 to full number the simpliest solution is to change cell formatint to NUMBER and set the decimal places to 0.

Sep 17, 2007 | Microsoft Office Standard for PC

Not finding what you are looking for?
Microsoft Office Standard for PC Logo

Related Topics:

39 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Business & Productivity Software Experts

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers


Level 3 Expert

18259 Answers

Sudeep Chatterjee
Sudeep Chatterjee

Level 3 Expert

3267 Answers

Are you a Microsoft Business and Productivity Software Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides