Forum Discussion
Excel and Julian Date - has something change recently
I have been exporting from a mamangement software program both CVS and EXCEL files. I do alot of sorting by dates and just within the last 3 weeks the exports are coming over in Julian but when you look at the formula box it shows that it is in the desired date format. Have bothered everyone i know about why I can not get the data in the column to show up in desire date format vs. Julian #'s.
3 Replies
Just my take on this, nothing has changed in Excel that I've heard of in this regard. Your image looks like a formatting issue that might be caused by a change in the source management software program, or maybe in the destination workbook that you're not aware of if it's a template of any kind. Until you find out why that is (if my suspicion is correct; maybe it's not), you can copy any empty cell, select the numeric range, paste special for Add in the Operation section, hit OK and then format for date as desired. I did that on a replica of your image data here. It's albeit a clunky workaround but something is going on in the export process that as far as I know, in my opinion, and speaking to your post's Subject line, is not due to a change in Excel.
Hello Thomas - I actually discovered that it is a MSO issue with Excel both in version 10 and 13. The fix simple - pressing the Ctrl key with the Tilde key simultaneously and the Julian number show now in the desired date format. Thank you for the work around.
...and thank you for the update!
