Display zero at the beginning of number in excel cell?

How to display zero (0) at the beginning of any number in excel cell?

Have you ever tried to do this in excel? If you try to add 0 at the beginning of any number in excel cell, that number will disappear and display remaining number. Following is the simple method to display zero at the beginning of any number of fixed length.

If you want three digits fixed length number in any one column. For example 022, 035, 080 in one column follow the below steps:

• Fill that numbers in one column that will look like 22, 35, and 80.
• 
  
  
  
  
• Select column, right click and select format cell as shown below.
• 
  
  
• In number Tab, select Custom.
• 
  
  
• Make type field empty and fill 000 manually in that field.
• 
  
  
• Press OK.
  

Excel useful shortcut keys

Keys Combination	Action/Description
ALT+SHIFT+F1	Inserts a new worksheet.
SHIFT+F2	Adds/Edits a cell comment.
SHIFT+F3	Displays the Insert Function dialog box.
SHIFT+F6	Switches between the worksheet
SHIFT+F8	Enables you to add a nonadjacent cell.
ALT+F8	Displays the Macro dialog box to create.
SHIFT+F9	Calculates the active worksheet.
SHIFT+F10	Displays the shortcut menu for a selected item.
ALT+SHIFT+F10	Displays the menu or message for a smart tag.
SHIFT+F11	Inserts a new worksheet.
ALT+F11	Opens the Microsoft Visual Basic Editor
ARROW KEYS	Move one cell up, down, left, or right in a worksheet.
CTRL+ARROW KEY	Moves to the edge of the current data region in a worksheet.
SHIFT+ARROW KEY	Selection of cells by one cell.
CTRL+SHIFT+ARROW KEY	Selection of cells to the last nonblank cell in the same column or row.
BACKSPACE	Clears the content of the active cell
DELETE	Remove the cell content
CTRL+END	Moves to the last cell on a worksheet
CTRL+SHIFT+END	Selection of cells to the last used cell on the worksheet.
ENTER	Completes a cell entry and selects the cell below.
ALT+ENTER	Starts a new line in the same cell.
SHIFT+ENTER	Completes a cell entry and selects the cell above.
ESC	Cancels an entry in the cell.
HOME	Moves to the beginning of a row.
CTRL+HOME	Moves to the beginning of a worksheet.
CTRL+SHIFT+HOME	Selection of cells to the beginning of the worksheet.
PAGE DOWN	Moves one screen down in a worksheet.
ALT+PAGE DOWN	Moves one screen to the right in a worksheet.
CTRL+PAGE DOWN	Moves to the next sheet in a workbook.
CTRL+SHIFT+PAGE DOWN	Selects the current and next sheet in a workbook.
PAGE UP	Moves one screen up in a worksheet.
ALT+PAGE UP	Moves one screen to the left in a worksheet.
CTRL+PAGE UP	Moves to the previous sheet in a workbook.
CTRL+SHIFT+PAGE UP	Selects the current and previous sheet in a workbook.
SPACEBAR	One space, selects or clears a check box.
CTRL+SPACEBAR	Selects an entire column in a worksheet.
SHIFT+SPACEBAR	Selects an entire row in a worksheet.
CTRL+SHIFT+SPACEBAR	Selects the entire worksheet.
ALT+SPACEBAR	Displays the Control menu for the Microsoft Office Excel window.
TAB	Moves one cell to the right in a worksheet.
SHIFT+TAB	Moves to the previous cell in a worksheet
CTRL+TAB	Switches to the next tab in dialog box.
CTRL+SHIFT+TAB	Switches to the previous tab in a dialog box.

Excel control combination shortcut keys

CTRL Key Combination	Action/Description
CTRL+A	Select all.
CTRL+B	Apply bold/removes bold formatting.
CTRL+C	Copy the selected cells.
CTRL+D	Fill Down contents and format of the topmost cell.
CTRL+F	Displays the Find and Replace dialog box and Find tab selected.
CTRL+G	Displays the Go To dialog box.
CTRL+H	Displays the Find and Replace dialog box and the Replace tab selected.
CTRL+I	Apply/removes italic formatting to the selected text.
CTRL+K	Displays the Insert Hyperlink dialog box.
CTRL+L	Displays the Create Table dialog box for selected cell/cells.
CTRL+N	Creates a new, blank workbook.
CTRL+O	Displays the Open dialog box.
CTRL+P	Displays the Print tab.
CTRL+R	Fill Right the contents and format of the leftmost cell.
CTRL+S	Saves the active file.
CTRL+T	Displays the Create Table dialog box.
CTRL+U	Apply/removes underlining.
CTRL+V	Paste the contents of the Clipboard at the selected cell.
CTRL+W	Closes the selected workbook window.
CTRL+X	Cuts the selected cells.
CTRL+Y	Repeats the last command or action.
CTRL+Z	Undo to reverse the last action.
CTRL+1	Displays the Format Cells dialog box.
CTRL+2	Apply bold/removes bold formatting.
CTRL+3	Apply/removes italic formatting to the selected text.
CTRL+4	Apply/removes underlining.
CTRL+5	Apply/removes strikethrough.
CTRL+6	Alternates between hiding and displaying objects.
CTRL+8	Displays or hides the outline symbols.
CTRL+9	Hides the selected rows.
CTRL+0	Hides the selected columns.
CTRL+PgUp	Switches between worksheet tabs from left-to-right.
CTRL+PgDn	Switches between worksheet tabs from right-to-left.
CTRL+SHIFT+(	Unhides any hidden rows within the selection.
CTRL+SHIFT+&	Applies the outline border to the selected cells.
CTRL+SHIFT_	Removes the outline border from the selected cells.
CTRL+SHIFT+~	Apply the General number format.
CTRL+SHIFT+$	Apply the Currency format with two decimal places.
CTRL+SHIFT+%	Apply the Percentage format with no decimal places.
CTRL+SHIFT+^	Apply the Scientific number format with two decimal places.
CTRL+SHIFT+#	Apply the Date format.
CTRL+SHIFT+@	Apply the Time format.
CTRL+SHIFT+!	Apply the Number format with two decimal places.
CTRL+SHIFT+*	Selects the current region around the active cell.
CTRL+SHIFT+:	Enters the current time.
CTRL+SHIFT+"	Copies the value from the cell above the active cell into the cell or the Formula Bar.
CTRL+SHIFT+Plus (+)	Displays the Insert dialog box.
CTRL+Minus (-)	Displays the Delete dialog box.
CTRL+;	Enters the current date.
CTRL+`	Alternates between displaying cell values and displaying formulas in the worksheet.
CTRL+'	Copies a formula from the cell above the active cell into the cell or the Formula Bar.
CTRL+F1	Displays/hides the Microsoft Office Excel Ribbon.
CTRL+F2	Displays the Print Preview window.
CTRL+F4	Close the selected workbook window.
CTRL+F5	Restore the window size of the selected workbook window.
CTRL+F6	switches to the next workbook window if multiple workbook window is open
CTRL+F7	Performs the Move command on the workbook window when it is minimized.
CTRL+F8	Performs the Size command on the workbook window when it is minimized.
CTRL+ALT+F9	Calculates all worksheets in all open workbooks
CTRL+F9	Minimize a workbook window to an icon
CTRL+F10	Maximize/restore the selected workbook window.

Excel Function keys shortcuts

Function keys	Action/Description
F1	Displays Microsoft Office Excel Help.
F2	Edits the active cell and positions the insertion point at the end.
F3	Displays the Paste Name dialog box.
F4	Repeats the last command or action.
F5	Displays the Go To dialog box.
F6	Switches between the worksheet, Ribbon, task pane, and Zoom controls.
F7	Displays the Spelling dialog box.
F8	Turns extend mode on or off.
F9	Calculates all worksheets in all open workbooks.
F10	Turns key tips on or off.
F11	Creates a chart of the data in the current range.
F12	Displays the Save As dialog box.