![]() |
|
#1
|
|||
|
|||
![]()
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 ![]() ![]() |
#2
|
||||
|
||||
![]()
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. |
![]() |
|
![]() |
||||
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 |
![]() |
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 |
![]() |
ketanco | Project | 1 | 02-08-2012 02:20 PM |