If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Excel turning percentages into scientific notation
Hi,
We've got a batch programme that created a few hundred reports (person specific numbers in same layout). All it does is take numbers from a table and paste special values into the various locations in the template. Some of the rules about how it does this are involved, and I'd not be allowed to post the code, but believe me, that's all it's doing. Now here's my problem. It is picking up percentages from the source table and dropping them into the destination template. Both the source and destination cells are formatted as percentages. For some reason, about a third of the time, excel seems to decide that despite the source and destination both being percentages, it's going to turn the numbers into scientific notation. No, there's no "E"s anywhere in the number string. Anybody encountered anything like this before or know how to stop this? Cheers, Tom. |
Thread Tools | |
Display Modes | |
|
|