# 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

• 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

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

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).
goodluck!

Posted on Jan 02, 2017

SOURCE: What number can i be?

You can be a number between

8734
6523
4321
2101

Posted on Jul 21, 2010

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

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

×

my-video-file.mp4

×

## Related Questions:

### 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...

### 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

### 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.

Aug 10, 2011 | 2004 Audi TT

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

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

### 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!

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

### 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

### 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 21?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 64?6
J 62?3
"s Toggles display between a mixed
number and an improper fraction.
30 F 4 30?4
"s 71?2
"s 15?2
"s 71?2
"y Toggles display between fraction and
decimal.
55 F 24 55?24
"y 2.291666667
"y 27?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

### 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

### Reset users pin

Apr 23, 2009 | Minolta Office Equipment & Supplies

### Speed dial list

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

#### Related Topics:

37 people viewed this question

Level 3 Expert

Level 3 Expert

Level 3 Expert