Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > comp.soft-sys.math.mathematica > #9197
| From | ruesche83@gmail.com |
|---|---|
| Newsgroups | comp.soft-sys.math.mathematica |
| Subject | Exporting a formula to Excel via copypaste |
| Date | 2012-03-22 10:52 +0000 |
| Organization | Steven M. Christensen and Associates, Inc and MathTensor, Inc. |
| Message-ID | <jkf09d$8kq$1@smc.vnet.net> (permalink) |
Hi there I'm trying to copy a fromula from mathematica a and paste it to excel. It is a polynomial. Something like: -0.00488067+0.000981042 dff+0.000109406 dff^2+1.83066*10^-8 Now, there are two problems: - The exponential is written as 10^-8. Which is not compatible with excel. This issue can be solve by using ScientificForm. - The second problem: Excel wants asterisks (*) for the multiplication. This is solved by doing it this way: ScientificForm[rhofit, NumberMultiplier -> "*"] Now, the problem is, that NumberMultiplier only adds asterisks where you have number, but not if you have variables. Any idea to replace the spaces with asterisks? Any help would be highly appreciated. Philipp
Back to comp.soft-sys.math.mathematica | Previous | Next — Next in thread | Find similar | Unroll thread
Exporting a formula to Excel via copypaste ruesche83@gmail.com - 2012-03-22 10:52 +0000 Re: Exporting a formula to Excel via copypaste A Retey <awnl@gmx-topmail.de> - 2012-03-23 06:31 +0000
csiph-web