How to Remove the Date From a Cell on an Excel Spreadsheet

Save

Microsoft Excel gives you a multitude of options for cell formats. Format a cell to display decimals to two places and Excel will round every input to two decimal places; format for fractions and Excel will display numbers in fractional form; format for date and Excel will convert every number you input to a date. If you are entering numbers into a cell and a date appears, all you need to do is format the cell and tell Excel what kind of number you are expecting to see in the cell.

  • Right-click on the cell.

  • Choose "Format Cells".

  • Click on the "Number" tab. Click on a number format that you would like. For example, choose "decimal".

  • Press "OK".

Tips & Warnings

  • Apply the formatting to a range of cells by clicking on a column or row identifier (for example, "A" or "1") and then right-clicking.

References

  • Photo Credit keyboard image by Fyerne from Fotolia.com
Promoted By Zergnet

Comments

You May Also Like

Related Searches

Check It Out

Geek Vs Geek: Robot battles, hoverboard drag race, and more

M
Is DIY in your DNA? Become part of our maker community.
Submit Your Work!