Changing the Cell Formatting from Date to Number in Microsoft Excel

To change the cell format from date to number we convert the formatting into General Format in Microsoft Excel.

There are three different ways to change the formatting from date to number.

1st Shortcut Key

2nd Format Cells

3rd Command Button

Let’s take an example and understand how we can convert cell formatting from date to number or general formatting.

We have date in column D. In column E we will learn to convert the cell format from date to number through shortcut key, in column F through Format Cells and in Column G through Command button.

img1
 
To change the cell formatting by using the Shortcut Key

Follow below given steps:-

  • Select the range E3:E11.
  • Press the key Ctrl+Shift+~ on your keyboard.
  • Cells formatting will get convert into numbers.

img2
 
To change the cell formatting by using Format Cells

Follow below given steps:-

  • Select the range F3:F11 and press the key Ctrl+1 on your keyboard.
  • A format Cells dialog box will appear.

img3
 

  • In the Number Tab, Click on General.
  • We can see the formatting in sample preview.
  • The function will convert the formatting into general formatting.

img4
 
img5
 
To change the cell formatting by using Command Button

Follow below given steps:-

  • Select the range G3:G11.
  • Go to Home Tab click on General in the Number group.

img6
 

  • Date format will get convert in General format.

img7
 

These are the ways in which we can convert the cell formatting from date to number in Microsoft Excel.

 

image 48

 

If you liked our blogs, share it with your friends on Facebook. And also you can follow us on Twitter and Facebook.
We would love to hear from you, do let us know how we can improve, complement or innovate our work and make it better for you. Write us at info@exceltip.com

 
 

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.

Visit Us On TwitterVisit Us On FacebookVisit Us On Google PlusVisit Us On Youtube