I have an excel sheet with over 6000 rows and each row has a cell with the date in it. Unfortunately, the date is formatted as a number like "20000515" would be 05-15-2000. When I go into the cell and add the dashes to make it "2000-05-15" it formats correctly however I do not want to go through in each individual cell and make this change. I have tried going under the "number" section in the Home tab to try and reformat, and I have also tried recording a macro. I may do doing this wrong. Any help would be greatly appreciated.
Reformatting numbers to date in excel
59 Views Asked by Brian E At
0
There are 0 best solutions below
Related Questions in EXCEL
- Concatenate excel cell string within cell reference string
- Use hidden information for filtering data
- Using Vlookup in Excel sheet to match substring
- Import from api into multiple excel cells
- Loop through list of files and open them
- Pull and push data from and into sql databases using Excel VBA without pasting the data in Excel sheets
- Loop with equation for upper limit
- excel vba null value in array
- Why is my xml file having these after convert from excel?
- TextToColumns function uses wrong delimiter
- Difference between two dates in excel 2013
- Concatenate string and number as number
- Why in a pivot the "include new items in manual filter" option is grey out when source is a powerpivot?
- Count Unique Values Repeated Dates
- How do I extract info from crunchbase
Related Questions in DATE
- PLSQL Need REFCURSOR DATE + TIME
- Pandas date ranges and averaging the counts
- javascript date validation to check whether it exceeds exactly next year's date
- How to INSERT date in PHP & Mysqli
- Create a list of sequential monthly dates in PHP given initial date and quantity
- Date parse with Timezone - Android
- RAILS: date_select validation
- Having trouble writing a calendar, I couldn't find a detailed guide answering my questions anywhere
- Julian Date Conversion SQL
- SQL find out how many days into year date is
- Algorithm to find the Gregorian date of the Chinese New Year of a certain Gregorian year
- Angularjs, date input : enter a date manually with a specific format
- How to convert a Microsoft SQL date to a vba string?
- Why does new java.text.SimpleDateFormat("EEEE").format(new java.util.Date(2015, 6, 9)) return the wrong day of the week?
- SQL Column Numeric to DATE
Related Questions in REFORMATTING
- MySQL Workbench > Plugins > Utilities > Reformat SQL Query
- delphi reformatter suddenly missing
- Reformat unstructured Pandas DataFrame
- Is there a way to use awk to count the number of rows between 2 flags and input that number into a specific field?
- Reformat an object array by grouping by one common element
- Reformatting a lot of classes
- Mysql changes my html tags rendering them useless
- Pandas: reformatting CSV data from single column into multiple new columns
- Wide To Long Data Assigning Values Based on Columns
- Saving df into txt file breaks up lines
- Reformatting results, Turning Columns to Rows, MYSQL
- Object Initializer Formatting
- Disable Resharper auto-formatting around certain blocks of code
- Reformatting numbers to date in excel
- convert xml date and time using javascript
Trending Questions
- UIImageView Frame Doesn't Reflect Constraints
- Is it possible to use adb commands to click on a view by finding its ID?
- How to create a new web character symbol recognizable by html/javascript?
- Why isn't my CSS3 animation smooth in Google Chrome (but very smooth on other browsers)?
- Heap Gives Page Fault
- Connect ffmpeg to Visual Studio 2008
- Both Object- and ValueAnimator jumps when Duration is set above API LvL 24
- How to avoid default initialization of objects in std::vector?
- second argument of the command line arguments in a format other than char** argv or char* argv[]
- How to improve efficiency of algorithm which generates next lexicographic permutation?
- Navigating to the another actvity app getting crash in android
- How to read the particular message format in android and store in sqlite database?
- Resetting inventory status after order is cancelled
- Efficiently compute powers of X in SSE/AVX
- Insert into an external database using ajax and php : POST 500 (Internal Server Error)
Popular Questions
- How do I undo the most recent local commits in Git?
- How can I remove a specific item from an array in JavaScript?
- How do I delete a Git branch locally and remotely?
- Find all files containing a specific text (string) on Linux?
- How do I revert a Git repository to a previous commit?
- How do I create an HTML button that acts like a link?
- How do I check out a remote Git branch?
- How do I force "git pull" to overwrite local files?
- How do I list all files of a directory?
- How to check whether a string contains a substring in JavaScript?
- How do I redirect to another webpage?
- How can I iterate over rows in a Pandas DataFrame?
- How do I convert a String to an int in Java?
- Does Python have a string 'contains' substring method?
- How do I check if a string contains a specific word?