LifeTricks.com 
USER CP
Site Navigation 
UPVOTE
UP
57
DOWN
DOWNVOTE
Excel Spreadsheet - Excel Spreadsheet Trick: Input Values Starting with 0
UPVOTE
57
DOWNVOTE
  • life tricks short link

Excel Spreadsheet Trick: Input Values Starting with 0

Excel Spreadsheet

When an input value starts with zero, Excel will delete the zero by default. Rather than resetting the Format Cells, this problem can be easily solved by adding a single quote mark ahead of the first zero, as shown.

Trick Source:

Is this trick using work of your own without attribution? Click here to PM the user and let them know!


User Comments