Question about Microsoft Excel 2010

1 Answer

How to display numbers in a cell to 7 digits - Microsoft Excel 2010

Posted by on

1 Answer

  • Level 3:

    An expert who has achieved level 3 by getting 1000 points

    All-Star:

    An expert that got 10 achievements.

    MVP:

    An expert that got 5 achievements.

    Vice President:

    An expert whose answer got voted for 100 times.

  • Master
  • 542 Answers

Right click on the cell that you need to display as a 7 digit number and then choose FORMAT CELL the choose CUSTOM in the NUMBER tab and type seven zeros into the TYPE field, you will see in the preview that the display is formatted as you have requested and the added bonus is that the field still retains is numeric characteristics and can be easily used for calculations etc.

Posted on May 08, 2013

1 Suggested Answer

6ya6ya
  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

Hi,
a 6ya expert can help you resolve that issue over the phone in a minute or two.
best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
the service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.
goodluck!

Posted on Jan 02, 2017

Add Your Answer

Uploading: 0%

my-video-file.mp4

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

×

Loading...
Loading...

Related Questions:

1 Answer

Display numbers in a cell to 7 digits


Right click on the cell that you need to display as a 7 digit number and then choose FORMAT CELL the choose CUSTOM in the NUMBER tab and type seven zeros into the TYPE field, you will see in the preview that the display is formatted as you have requested and the added bonus is that the field still retains is numeric characteristics and can be easily used for calculations etc.

May 01, 2013 | Microsoft Excel 2010

1 Answer

How can iget the serial number


The IMEI number is unique the each mobile phone.The number is printed on the label under the battery.You can also get the IMEI number by entering this onyour phone *#06# It will then display your IMEI number andyou may also get a unique global serial number. Your IMEI number should be 15 digits.

Mar 25, 2012 | HTC 7 Surround Cell Phone

1 Answer

How do I clear all information from a LG VX5500 Cell Phone before returning it.


Steps to Reset Settings
This resets the phone to factory default settings.

  1. With the flip open, press the OK key [Menu].
  2. Press 9 or Settings & Tools.
  3. Press 6 or Phone Settings.
  4. Press 7 or Security.
  5. Enter lock code. The default lock code is the last 4 digits of your phone number.
  6. Press 5 or Reset Default.
  7. Press OK after reading the warning message.
  8. Select Revert by pressing OK. A confirmation message is displayed briefly before the phone resets itself.

Steps to Restore Phone
This erases all user data and contact information entered in phone memory.

  1. With the flip open, press the OK key [Menu].
  2. Press 9 or Settings & Tools.
  3. Press 6 or Phone Settings.
  4. Press 7 or Security.
  5. Enter lock code. The default lock code is the last 4 digits of your phone number.
  6. Press 6 or Restore Phone.
  7. Press OK after reading the warning message.
  8. Enter lock code. The default lock code is the last 4 digits of your phone number.

Sep 14, 2011 | LG VX5500 Cell Phone

1 Answer

Can this convert decimal measurements to fractions of an inch


Enters a proper or improper fraction,
b?c (b { 6 digits, c { 3 digits). When
possible, improper fractions are
displayed as mixed numbers.
3 F 4 3?4
8 3 J 21?4
Single-variable functions display
decimal results.
1 F 2 0 0.25
a F b F c Enters the mixed fraction a b?c.
(a, b, c { 3 digits each, with the total
digits { 8).
6 F 4 F 6 64?6
J 62?3
"s Toggles display between a mixed
number and an improper fraction.
30 F 4 30?4
"s 71?2
"s 15?2
"s 71?2
"y Toggles display between fraction and
decimal.
55 F 24 55?24
"y 2.291666667
"y 27?24
If a result would overflow or if fixed decimal is 0, no
fraction to decimal conversion occurs. It is not an error.
Denominator must be a whole number {999.

Nov 28, 2010 | Texas Instruments TI-30XA Calculator

1 Answer

How do I turn ******** off on my Jitterbug cellphone ?


If I understand your problem, you are trying to dial a number and the phone is displaying a series of asterisks instead of the correct number. If you misdial and would like to delete an entry to dial the correct number, press the NO button to delete digit-by-digit.

If you need further assistance or I have not addressed your issue, please call our Customer Service department at (800) 733-6632. We are available 24/7.

Nov 02, 2010 | One Touch Jitterbug One-Touch Cellular...

1 Answer

Unlock nokia 7100 from tmobile


1. Press #
2. Press * three times = p
3. Press * four times = w
4. Press * twice = +
5. Enter the unlock code (15 digit number)
6. Press * twice = +
7. Press 1, then # and the display should read “SIM Restriction Off”

15 digit unlock code shown below is just an example.

nokian96-unlock.png

Sep 04, 2010 | Nokia 7100 Supernova Cell Phone

1 Answer

My wife has a Nokia 6650 and when people call the number is displayed but he name won't she is getting very upset and the book sucks.


Caller ID works by displaying the caller infomation that is sent. When you receive the caller ID, it first tries to pair it up with a name in the address book, and if nothing is found, it just displays the number.
If you want the contact's name to show, then you must save it exactly as the caller ID displays it. Most often, only 7 digits are put in, when it needs to be the full 10 digits.

Jun 29, 2009 | Nokia 6650 Cellular Phone

1 Answer

Reset users pin


Settings for the Administrator Mode 1 Call the Utility Mode to the Display. ❍ Calling the Utility Mode to the Display (p.7-1) 2 Making sure that ?U--? appears on the Display, enter ?5? from the 10- Key Pad. 3 Press the [Start] key. Input Account Procedure (A-2) 1 Call the Administrator Mode to the Display. ❍ Settings for the Administrator Mode (p.7-16) 2 Making sure that ?Ad-? appears on the Display, enter ?1? from the 10- Key Pad. 3 Press the [Start] key. 4 Making sure that ?A--? appears on the Display, enter ?2? from the 10- Key Pad. 5 Press the [Start] key. 6 Enter the 3-digit account number from the 10-Key Pad. ? Do you know the restrictions on entering the account number? ➜ The account number must be in three digits ranging from 001 to 999. ➜ If an account number entered already exists, the entry will be rejected. Enter a different number. 7 Press the [Start] key. This stores the account number. ✎ Tip To program another account number successively, repeat steps 4 through 7. Using the Utility Mode 7 Di152/Di183 7-21 Delete Account Procedure (A-3) 1 Call the Administrator Mode to the Display. ❍ Settings for the Administrator Mode (p.7-16) 2 Making sure that ?Ad-? appears on the Display, enter ?1? from the 10- Key Pad. 3 Press the [Start] key. 4 Making sure that ?A--? appears on the Display, enter ?3? from the 10- Key Pad. 5 Press the [Start] key. 6 Press [ ] or [ ] key to select the account number to be deleted. 7 Press the [Start] key. The selected account number will be deleted. ? Do you know what to do to delete another account number? ➜ Repeat steps 4 through 7. 7 Using the Utility Mode You can go to the Konicaminolta US web site and down load a operators manual for youself

Apr 23, 2009 | Minolta Office Equipment & Supplies

1 Answer

I have a texas instrument TI-36X calculator


Hi,
Use the [a b/c] key.
7 [a b/c] 11 displays 7u11. Numerator can have up to 6 digits. Denominator can have up to 3 digits
7[1 b/c] 11 [a b/c] 19 displays 7u11u19 meaning 7 and 11/19. The vaiois numbers can have up to three digits each, but the total number of digits must be less than or equal to 8.

The key combination [2nd][d/c] toggles display between mixed numbers and improper fractions.
The key combination [3rd][F<=>D] switches between fraction and decimals. (Not all decimals can beconverted to fractions: see limitations above).

Hoe it helps.

Apr 14, 2009 | Texas Instruments TI-36X Scientific...

1 Answer

AREA CODE


Just purchased the GE 25922 today. Looks like you can skip (ignore) the option to enter an area code.

United States' Area Codes are three-digit numbers. If the phone 'requires' entering a number you can use any three digit number. The purpose of this option is to display a local telephone number with only the 7 digits.

Example:
603 - 123 - 4567
'603' is the area code
123-4567 is the 7-digit local number.

If the area code option is programmed to '603', then if that number called '123-4567' would display on the Caller ID display.
Which now reminds me: you would need to also subscribe to Caller ID with the Telephone Company for the numberic display to occur.

Oct 27, 2007 | GE 25922 Cordless Phone

Not finding what you are looking for?
Microsoft Excel 2010 Logo

37 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

micky dee

Level 3 Expert

2727 Answers

Piyal Perera
Piyal Perera

Level 3 Expert

528 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18391 Answers

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

Answer questions

Manuals & User Guides

Loading...