I have source data with values like 1.5 & 100. The are stored in a table where the data type is double. I need to eventually export it to excel so that the numbers are formatted like 1.50 & 100.00.
I need the field type in excel to remain a number which I believe requires that the table I'm exporting from needs to be set as a number. Additionally, I don't think I can create a spec for export to excel - which I thought would solve the provlem.
Any ideas how to make this happen?