A few words of thanks would be greatly appreciated.

Excel- Convert the date format into general format

Latest update on October 19, 2020 at 02:44 PM by Irene_Burn .

In this short article we will show you how to convert the date from date format into general format and still keep it shown under Excel 2003.

Solution

Try this formula :

=TEXT(A2,"mm/dd/yyyy")

Foto: © Unsplash

Convert date to general in excel
How to convert date to general in excel - Best answers
Excel convert date to general - Best answers
Formula to convert number to words in excel 2016 - How-To - Excel
How to convert number to words in excel in rupees without vba ✓ - Forum - Excel
Convert number to words in excel 2007 ✓ - Forum - Word
How to convert numbers into words in excel in pakistani rupees ✓ - Forum - Office Software
Convert yyyymmdd to date in excel ✓ - Forum - Excel

This document, titled « Excel- Convert the date format into general format », is available under the Creative Commons license. Any copy, reuse, or modification of the content should be sufficiently credited to CCM (ccm.net).

Excel - A macro to edit file name

Excel - Update calculations

2 vote - 5.0/5

2 Comments

Report

Anonymous User
May 29, 2020 at 11:25 AM

Brilliant!!! THANK YOU!!!

Report

Anonymous User
Dec 31, 2019 at 05:11 AM

Thank you this tip.

Solution

Related