When I export a report with a text field (financial date) to excel the data is changed!!!
2005/06 changes to 38504
2004/05 changes to 38108
I presumed it is dividing the values but the arithmetic does not add up – the field in excel is a general field so I have no idea why it is changing.
Any ideas how I can get this to export the actual data? The only way I have found so far it using | (pipe) i.e. 2005|06 however this is the delimiter that I have to use for importing data in the first place!!!!
Any ideas?
2005/06 changes to 38504
2004/05 changes to 38108
I presumed it is dividing the values but the arithmetic does not add up – the field in excel is a general field so I have no idea why it is changing.
Any ideas how I can get this to export the actual data? The only way I have found so far it using | (pipe) i.e. 2005|06 however this is the delimiter that I have to use for importing data in the first place!!!!
Any ideas?