Microsoft Office Standard for PC Logo

Related Topics:

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 kiso on

1 Answer

Anonymous

  • Level 2:

    An expert who has achieved level 2 by getting 100 points

    MVP:

    An expert that got 5 achievements.

    Mentor:

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

    Governor:

    An expert whose answer got voted for 20 times.

  • Expert
  • 112 Answers

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

Posted on Sep 06, 2007

Ad

Add Your Answer

×

Uploading: 0%

my-video-file.mp4

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

×

Loading...
Loading...

Related Questions:

0helpful
1answer

Hello i have forgot my lock code for my nokia N76 and my IMEI is 352054/02/114169/3 please urgent

Don't FORMAT the phone until you have tried everything. Default Nokia lock/security code is 12345, it's always a 5-digit code, so even if you entered a new lock code consisting of 6-digits, it will only save the first 5-digits. So try 12345 first, if not, try to remember if you changed it, and used ONLY the first 5-digit of whatever number code you used.
Nov 27, 2013 • Cell Phones
0helpful
1answer

What is the factory reset code?

You shouldn't need a code to reset the handset, but the base requires a PIN (Default PIN is "0000"). I have typed the instructions below, but here is a link to the online PDF: http://dl.owneriq.net/5/5d7cdc19-660a-8934-7d52-e5205df74c27.pdf

Handset:
  1. Menu -> Settings ->Handset -> Reset Handset
  2. OK - press the control key to confirm
  3. End Call Button - Long Press (Idle Status)

This will reset individual settings & changes made by you. It will not affect the directory, calls list, SMS lists, the handset registration to the base and stored pictures or ringer melodies.
Base:
  1. Menu -> Settings -> Base -> Base Reset
  2. Enter the system PIN (Default PIN "0000" or the PIN you created)
  3. OK - Press the control key to confirm

If you already changed the system PIN to one of your own you will need to contact the Siemens Hotline for "expert intervention" (their words, not mine).Online: http://www.gigaset.com/en_US/support/contact.htmlWarranty Number: 1-866-247-8758 / Toll FreeOpening Hours: Sun. 6 pm - Fri. 6 pm continuously (EST)
0helpful
1answer

BT Aura 1500 Quad telephone - calls list freezing

BT gave me solution, which (so far) seems to work:
Reset the software of the telephone to default settings...
On any handset - 1. Press 'menu' 2. Scroll to 'settings' & press 'ok' 3. Scroll to 'base' & press 'ok' 4. Scroll to 'reset base' & press 'ok' 5. 'System PIN' will be displayed - enter '0000' (unless you have altered the default pin number) 6. Press 'ok' 7. Press 'yes' 8. Switch the main base station off at the power & remove the batteries from all handsets for approximately 30 minutes .
This didn't reset my address book (thank goodness) but did reset some other settings, such as time/date, OGM, group ringtones etc.
1helpful
1answer

How to reset a password on vizio p42hdtv10a tv i forgot the passwored

Hello
To change password use the number pad and type '0000' or whatever password you have changed it to previously, then press OK.
Actual proceedings are:

[1] Press the MENU button to open the main
On Screen Display (OSD) menu.

[2] Press the [

three times until the Parental Control
menu opens.

[3] Press the [Down] button on the remote control

to highlight Parental Lock Enable. The
"Key-In Access Code" window opens.

[4] Use the number pad to type the default

password (0000) or whatever password

you have changed it to previously, then
press OK.

[5] Press the [Down] button on the remote control
to highlight Access Code Edit.

[6] Press the [=>] button on the remote control

to enter the submenu. You will need to

use the number pad to type default (or

what you changed to previously) password
first

[7] Use the number pad to type the new
password.
[8] Confirm the new password by retyping it.
[9] Press EXIT button on the remote control immediately to exit the OSD menu

1helpful
2answers

I am trying to update the firmware on my new A580IP phone using my web browser connected to the base station. I get a transmission error "0" every time. Is the default download web site...

Hi,

According to the effectiveness of the past.
To update the firmware for gigaset A580ip not require you to download it,
just do the update directly through gigaset on-line
,
follow the steps below.

1> Menu » Settings » Base » Firmware Update
2> Enter base station system PIN (default setting: 0000)
3> Press the display key "Yes" to start the download
If your firmware is already up to date, the handset informs you. No action is needed then.

How to check for your firmware version:

Via Web Configurator: Status » Firmware version » The first 5 digits indicate the number of the firmware update

If you are in a call (> 8 sec): Menu » Service-Info » Scroll to list entry number 4. The first 5 digits indicate the number of the firmware update


regards
4helpful
1answer

I am having difficulty obtaining drivers O 3000 N100 OS XP Base System Device PCI bus 5, device 6, function 2 Base System Device PCI bus 5, device 6, function 3 Base System Device...

Base System Device drivers are usually installed by what the manufacturer calls "Chipset" drivers. If you are running Windows XP, there is an Intel Chipset driver available at the Lenovo Support Page for your model. If you are running an Operating System other than Windows XP, I would go to the above page and compare the drivers listed there with what you are seeing in Device Manager. Install the ones that are missing. Hope this helps!
0helpful
1answer

The orange lights are flashing, is there something wrong?

Try:



1 Resolution may vary based on printer driver setting. Color ink droplets can be placed with a horizontal pitch of 1/4800 inch at minimum.
2 PPM print speeds are based on the highest speed printer driver mode. Photo print speeds are based on the default mode driver setting using Canon Photo Paper Plus Glossy paper. Print speeds will vary depending on system configuration, interface, software, document complexity, print mode, types of paper used and page coverage. CPM copy speeds based on fast mode setting using plain paper. Copy speeds may vary based on document complexity, copy mode, page coverage and number of copies.
3 USB 2.0 Hi-Speed requires Windows XP, 2000 or Mac OS X operating systems. For Windows 98, Me and Mac OS X v.10.2 to 10.2.6 operating systems, the printer will operate at USB 1.1 specifications.
5helpful
2answers

Siemens gigaset 2420. how do i reset pin on desktop base corded station?

  1. I forgot the PIN number on my Gigaset 2XXX system base station. What can I do?
    Please complete the following steps to reset the system PIN on 2XXX back to 0000. On the system base station:
  • Press MENU.
  • Scroll to SYSTEM SETTINGS but do not press SELECT.
  • On the keypad, enter *65# (Star, 6, 5, Pound).
  • It will display "SYSTEM PIN RESET" and return to the idle screen.
  • Note: The base station system PIN will be reset to 0000

  1. I forgot the PIN number on my Gigaset 2XXX cordless handset. What can I do?
    Please complete the following steps to reset the cordless handset PIN on the 2XXX back to 0000.
  • Press MENU.
  • Scroll to MOBILE SETTINGS and press SELECT.
  • Scroll to LOCAL SETTINGS and press SELECT.
  • Scroll to CHANGE PIN and press SELECT.
  • On the keypad, enter *65# (Star, 6, 5, Pound).
  • Note: The handset PIN will be reset to 0000


1helpful
2answers

Not reading the disc

need a bit more info - are you playing a movie or running software installation?

If you need to change the drive region then do the following


1. Power on your DVD Player without a disc in the drawer.
- Wait for the "Loading" screen to finish and then the display reads "no disc".
Check which region your reader was bought in. (Large Number label is located on the rear of the Player. Region 1 to 6)
-on the remote control
2. Press the "Repeat"button. The "no disc" label on the screen will disapear.
3. According to the region your player was bought in, choose from the following button sequences.
- region 1, press buttons 2, 9, 3, 3, 4
- region 2, press buttons 5, 7, 5, 3, 8
- region 3, press buttons 5, 6, 7, 3, 2
- region 4, press buttons 7, 6, 8, 8, 4
- region 5, press buttons 5, 3, 8, 1, 4
- region 6, press buttons 2, 4, 4, 6, 2
4. The number in the top left corner of the screen shows you the current region. EG "1" for the US/Canada, "4" for Australia/NZ.....etc.
5. Now enter the new number for the region you require (1 to 6)...or simply enter 9 for "Multi-region". The number in the left hand corner of the screen will change to the number you enetered. Wait for the number to dispear. It will take around 15 seconds.
6. Now power off the DVD player with the button on the front of the unit. Now each time the unit is turned on it will be in the new region...or muti-region if region 9 was chosen.
7. If you wish to change the region again...or back to its original, go through the exact same sequence until step 5. Then you enter the different region number.
If you are unsuccesfull with the above code then it may be worth trying one of the resources below.
0helpful
1answer

My phone is doing whatever it wants and no matter what i push it goes to settings what can i do to stop this?

Try to reset the phone, it will delete everything on the phone, but it will restore the phone back to the factory settings. Follow the steps below:

1. While in standby mode, press the OK button for Menu
2. Select Settings & Tools, using the navigation keys
3. Select Phone Settings (6)
4. Select Security (6)
5. Enter the lock code, default password is the last 4 digits of cell phone number, unless it has been changed
6. Select Reset Settings (3)
7. Highlight Yes, using the navigation keys
8. Press the OK button to confirm resetting the handset to factory default settings

Not finding what you are looking for?

55 views

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

Steve Nordquist
Steve Nordquist

Level 3 Expert

982 Answers

Brad Brown

Level 3 Expert

19166 Answers

Mike

Level 3 Expert

4383 Answers

Are you a Microsoft Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...