I am using Crystal Reports 2008 with an Excel spreadsheet as my Data Source.
I have a column in my spreadsheet which is set a General (all values in this column are stored as text).
Within Crystal reports this field has been classified as a string field.
The values in this column are displayed as YYYYMMDD (example: 20150323), I would like this field to be displayed as DD-MMM-YYYY (example: 23-Mar-2015 ) in CR.
I'm guessing this would require a formula, please provide step by step on how I can accomplish this.