Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 03-29-2018, 10:51 AM
windseaker windseaker is offline Date conversions Windows XP Date conversions Office 2007
Novice
Date conversions
 
Join Date: Feb 2010
Posts: 19
windseaker is on a distinguished road
Default Date conversions

Here is issue, I have export data into excel but date converts to date format, any ideas how to get it back to text?

Data .CSV Convert

08-32 -------> Aug-32 -------> 08-32
08-34 -------> Aug-34 -------> 08-34
08-35 -------> Aug-35 -------> 08-35
12-35 -------> Dec-35 -------> 12-35


Reply With Quote
  #2  
Old 03-29-2018, 01:01 PM
NBVC's Avatar
NBVC NBVC is offline Date conversions Windows 10 Date conversions Office 2013
The Formula Guy
 
Join Date: Mar 2012
Location: Mississauga, CANADA
Posts: 215
NBVC will become famous soon enoughNBVC will become famous soon enough
Default

Format the cells as Number > Custom > mm-yy

or, to ensure it stays in your format, in another column enter formula =TEXT(A1,"mm-yy")

Then you can copy and paste special > Values over original and then delete formulas.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Unwanted conversions with PowerPoint presentations xlcfdp PowerPoint 0 10-03-2017 02:04 PM
Microsoft Project 2016 print specific date range stuck on one date martinsalmon Project 1 10-12-2016 11:36 AM
Date conversions How can a document have the same date modified/create date, yes have have actual file content? legaleagle Word 15 01-07-2015 06:58 PM
Excel pivot table with a DATE value field for some reason stops at a certain date angie450 Excel Programming 2 08-19-2014 08:50 AM
Date conversions Meaning of current date vs status date when saving baselines ketanco Project 1 02-08-2012 02:20 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:49 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft