Hi All,

I can not perform any calculation on the data exported to excel from CRM 3.0.
I got a workaround to convert the field to numeric and do the calculation
but that is not a straight forward solution.
I am using Office 2000.
Has anybody come across this or any other straight solution.

Appreciate your help on this.
--
Thanks...
Manish Dixit

I assume you are trying to do an aggregate function on a column, like a sum()
or average() on a range of data. Normally, you could use the value()
function to convert text to a number on the fly, but value() doesn't work for
ranges. If the data export is dynamic, I don't know if Excel 2000 supports
dynamic data (I don't have a copy to use for testing), one of the properties
of the query is to preserve formatting, so you would only have to set the
formatting of the column to numeric once, then save the workbook. The other
way to achieve what you want is use the value() formula to put the numbers in
a new column and perform your calculations based on the new column. Again, I
don't have Excel 2000 to test any of this, so you may have already tried
these techniques and found out they don't work.
--
Richard Riddle
CRM Developer
Autonomix


"Manish" wrote:

On May 16, 1:36*am, Richard Riddle
<RichardRid...@discussions.microsoft.com> wrote:
Can you highlight the data in the exported sheet, select copy, then
open up a new worksheet and do a edit->paste special... and select
values only