Converting excel text sting to numbers

Hi all,

We have just started exporting our excel reports and would like some
assistance in cleaning up the data before analysing it.

When we export to excel the data comes out as a text string - which means
excel doesn’t automatically recognise that it is a number. We have found
the standard excel tricks (multiply all cells by 1 or highlight all cells
with the error and convert) but we were wondering if there was a faster way
to clean up the data? Is there a way that you can export this data so excel
automatically realises it is a number and not a text sting? Has someone
perhaps already built a macro for this?

Would appreciate any help!

Have a great weekend,

Monique

*Support our current crowdfunding campaign to provide solar energy to
India’s urban slums:
www.chipin.org.au/project/pollinateenergyhttp://www.chipin.org.au/project/PollinateEnergy

··· * [image: Pollinate Energy]

Bringing clean energy solutions to India’s urban poor.
Monique Alfris
Co-founder
e: mon.a@pollinateenergy.org
m: +91 8553 658 596
w: www.pollinateenergy.org
http://www.facebook.com/PollinateEnergy
http://www.twitter.com/PollinateEnergyhttp://www.linkedin.com/company/2934087?trk=tyah

Hi Monique,

Unfortunately right now CommCare exports all the data as text. We have
heard your feedback from others too, and it is something we plan to change
when we are able to revamp our exports. We will let you know via
commcare-users and our release notes when this feature is available.

In the meantime, the excel tricks you mention are the best way I know of to
proceed.

Thanks,
Amelia

··· On Fri, Apr 19, 2013 at 5:45 AM, Monique Alfris wrote:

Hi all,

We have just started exporting our excel reports and would like some
assistance in cleaning up the data before analysing it.

When we export to excel the data comes out as a text string - which means
excel doesn’t automatically recognise that it is a number. We have found
the standard excel tricks (multiply all cells by 1 or highlight all cells
with the error and convert) but we were wondering if there was a faster way
to clean up the data? Is there a way that you can export this data so excel
automatically realises it is a number and not a text sting? Has someone
perhaps already built a macro for this?

Would appreciate any help!

Have a great weekend,

Monique

*Support our current crowdfunding campaign to provide solar energy to
India’s urban slums: www.chipin.org.au/project/pollinateenergyhttp://www.chipin.org.au/project/PollinateEnergy
*
[image: Pollinate Energy] http://www.pollinateenergy.org/

Bringing clean energy solutions to India’s urban poor.
Monique Alfris
Co-founder
e: mon.a@pollinateenergy.org
m: +91 8553 658 596
w: www.pollinateenergy.org
http://www.facebook.com/PollinateEnergy http://www.twitter.com/PollinateEnergyhttp://www.linkedin.com/company/2934087?trk=tyah


You received this message because you are subscribed to the Google Groups
"commcare-users" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to commcare-users+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

Amelia,

Is this update to reporting (and I hope data exports) still in the works? My Excel is crashing trying to convert text to numbers.

Thanks!
Caitlin