Question about Microsoft Excel 2010

1 Answer

Display numbers in a cell to 7 digits

A 4 digit number to be displayed as a 7 digit number Eg. 234 as 0000234

Posted by on

Ad

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

Ad

4 Suggested Answers

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

Ad

SOURCE: What number can i be?

You can be a number between



8734
6523
4321
2101

Posted on Jul 21, 2010

  • 176 Answers

SOURCE: I am trying to type numbers with more than 3

  1. Right click on the the letter at the top of the column you are entering the larger numbers in and choose "format cells" from the drop down menu.
  2. Then click on "number" and this is where you can set the number of decimal places or other adjustments.
Thanks,
Robert

Posted on Feb 25, 2011

  • 104 Answers

SOURCE: When I enter the number

The number is too long to fit into the cell. Try expanding the cell or reducing the font size.

Posted on Mar 09, 2011

Add Your Answer

Uploading: 0%

my-video-file.mp4

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

×

Loading...
Loading...

Related Questions:

1 Answer

Factorial key


14! is an eleven-digit number. The only way your ten-digit calculator can display that number is to convert it to scientific notation. A twelve-digit calculator such as a TI-89 can display that number, but 23! is a 23-digit number and even a TI-89 cannot display that number.

Oct 25, 2013 | Texas Instruments BA-II Plus Pro...

1 Answer

How to 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

Hi I need to reset the radio for my A3 AUDI after a servive i have done. I have the 4 digit code but then what???


The sequence of programming for Audi radio is:
1. Push simultaneous "SCAN" and "RDS" keys until on the screen will appear "1000" displayed.
2. Release keys. No more push on "SCAN" and "RDS" keys because otherwise number "1000" will be considered as first safe code attempt.

For example: we have the security code "5079". Then:
3. By the no.# 1 key you will set up the first safe code digit. Push 5 times on the no.# 1 button. The "5" number will be setted.
4. By the no.# 2 key you will set up the second safe code digit. Push 10 times on the no.# 2 button. The "0" number will be setted.
5. By the no.# 3 key you will set up the third safe code digit. Push 7 times on the no.# 3 button. The "7" number will be setted.
6. By the no.# 4 key you will set up the four-th safe code digit. Push 9 times on the no.# 4 button. The "9" number will be setted.
7. Then push again simultaneous "SCAN" and "RDS" keys for confirm this safe code. On the screen will be displayed "SAFE" notice. Release keys! For few seconds a radio frequence will be displayed.

The radio is now ready for use!

Aug 10, 2011 | 2004 Audi TT

1 Answer

My radio only has six numbers,how do I put in 7 or9


It will depend on the make+model of your radio.

Find yours here ...CLICK HERE

The normal method ....eg ...a Ford is

Once the unit has been turned on the display will show 'CODE - - - -' Press preset [ 1 ] repeatedly for the first digit Press preset [ 2 ] repeatedly for the second digit Press preset [ 3 ] repeatedly for the third digit Press preset [ 4 ] repeatedly for the third digit To save the code press the [ 5 ] key to accept.

May 04, 2011 | Car Audio & Video

1 Answer

My radio does not work on my Cabrio. I get safty display and 1000 display.


IMPORTANT NOTE:
You must have the security anti-theft code for your VW radio from the car manufacturer, or from a VW dealer!
You can find the radio code at: http://www.radio-code.co.uk/

The sequence of programming for 2004 Volkswagen Passat radio is:
1. Push simultaneous "SCAN" and "RDS" keys until on the screen will appear "1000" displayed.
2. Release keys. No more push on "SCAN" and "RDS" keys because otherwise number "1000" will be considered as first safe code attempt.
For example: we have the security code "5079". Then:
3. By the no.# 1 key you will set up the first safe code digit. Push 5 times on the no.# 1 button. The "5" number will be setted.
4. By the no.# 2 key you will set up the second safe code digit. Push 10 times on the no.# 2 button. The "0" number will be setted.
5. By the no.# 3 key you will set up the third safe code digit. Push 7 times on the no.# 3 button. The "7" number will be setted.
6. By the no.# 4 key you will set up the four-th safe code digit. Push 9 times on the no.# 4 button. The "9" number will be setted.
7. Then push again simultaneous "SCAN" and "RDS" keys for confirm this safe code. On the screen will be displayed "SAFE" notice. Release keys! For few seconds a radio frequence will be displayed. The radio is now ready for use!

Feb 28, 2011 | 2000 Volkswagen Cabrio

3 Answers

How do i reprogram my speeddial numbers on jazz 4400?


Hello.

From NorStar Support:

To Program Personal Speed Dial Numbers: (Numbers 71 - 94 only.
1. Press the Feature button, then * 4
2. Enter the 2 digit code (71 - 94). that you want to assign to that phone number
3. Enter the telephone number, then press the OK softkey
4. Display will show: "Entry xx stored"

If the above doesn't work, try:

To Program Personal Speed Dial Numbers:
  1. Press [Feature] [*] [4]
  2. Enter a two-digit code from 71 to 94.
  3. Specify the external line by pressing a line button, a line pool button, or the intercom button. If you don't specify the external line, the system automatically chooses a line for the call.
  4. Dial the telephone number you want to program (up to 24 digits).
  5. Press [Hold].
  6. Record the code and number you have just programmed.
Hope this helps.

Feb 02, 2011 | NorStar Jazz Plus 4400 Corded 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 you tell with an imei number if the phone is a original or fake


To check whether your phone has an IMEI number:
1. Dial *#06# – A 15-digit number will be displayed on your handset.
2. To validate the IMEI, sms IMEI <15 digit IMEI number> to 53232 (Rs. 3 per SMS) For eg; IMEI 351869910223340 to 53232
  • Message displayed for correct IMEI – Success!!
  • Message displayed for incorrect IMEI – Alert!!! Invalid IMEI (tough luck).hope you have valid imei number.rate me if i have helped you

Sep 10, 2009 | Nokia 8800 Cellular Phone

1 Answer

Reset users pin


Settings for the Administrator Mode 1 Call the Utility Mode to the Display. &#10061; 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. &#10061; 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? &#10140; The account number must be in three digits ranging from 001 to 999. &#10140; 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. &#9998; 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. &#10061; 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? &#10140; 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

Speed dial list


***Storing a Number for Speed Dialing*** 1 Press Phone Book on the control panel. 2 Press Phone Book or the scroll button (􀂥 or 􀂊) to display ?Store&Edit? on the bottom line of the display. Press Enter. 3 Press Enter when ?Speed Dials? appears on the display. The display prompts you to enter a location number, showing the first available number. 4 Enter a one or two-digit speed dial number between 0 and 79, using the number keypad or scroll button (􀂥 or 􀂊), and press Enter. If a number is already stored in the location you chose, the display shows the number to allow you to change it. To start over with another speed-dial number, press Upper Level. 5 Enter the number you want to store using the number keypad and press Enter. To insert a pause between numbers, press Redial/Pause. A ?-? appears on the display. 6 To assign a name to the number, enter the name you want. For details about entering characters, see page 1.14. If you do not want to assign a name, skip this step. 7 Press Enter when the name appears correctly or without entering a name. 8 To store more fax numbers, repeat steps 4 through 7. To return to Standby mode, press Stop/Clear. ***Sending a Fax using a Speed Number**** 1 Feed the document(s) face up into the ADF. For details about loading a document, see page 2.2. 2 Adjust the document resolution to suit your fax needs. See page 2.3. If you need to change the darkness, see page 1.20. 3 Enter the speed dial number. ? For a one-digit speed dial number, press and hold the appropriate digit button. ? For a two-digit speed dial number, press the first digit button and hold the last digit button. The corresponding entry?s name briefly displays. 4 The document scans into the memory. The fax number stored in the speed dial location is automatically dialed. The document is sent when the remote fax machine answers

Aug 17, 2007 | Samsung SF-560 Plain Paper Laser Fax

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

2764 Answers

Piyal Perera
Piyal Perera

Level 3 Expert

528 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18394 Answers

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

Answer questions

Manuals & User Guides

Loading...