changing dates styles

  1. H

    Converting dates to numbers

    Hi everyone, First time poster here, appreciate any and all help. I have an excel document that continues to convert dates to numbers, and I have no idea why. For example, 2/2/14 changes automatically to 41672 and 4/4/14 changes automatically to 41733 (left adjusted in the cell). The cells...
    • hogesta
    • Thread
    • changing dates styles date and number date and time
    • Replies: 5
    • Forum: Excel Questions
  2. B

    Changing date styles

    Good morning, Can someone tell me how to change a euro date style of 20131109 in one cell (cell A1) to a standard date stlye as 11/9/2013 in another cell (Cell B1)? Thank you

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top