Prev: Userform Import problem
Next: Why is hyperlink staying imbedded when I insert rows into Excel?
From: mr-tom on 2 Jun 2010 09:14
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.
From: Luke M on 2 Jun 2010 15:56
Perhaps add a last line of code the reads:

Cells.NumberFormat = "0.00%"

--
Best Regards,

Luke M
"mr-tom" <mrtom(a)discussions.microsoft.com> wrote in message
news:736FA514-2E67-4DDB-8E71-79CDB31C9559(a)microsoft.com...
> 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.


From: mr-tom on 3 Jun 2010 03:51
Thanks, Luke.

Unfortunately the code is iterative - it copies across a vast number of
cells and only a small portion are percentages. It would be a major rewrite
to divide the programme into a percentage component and an "everything else"
component in order to add this line.

But genuinely thanks - if our system didn't cover such a range of stuff, it
would have been a good fix.

"Luke M" wrote:

> Perhaps add a last line of code the reads:
>
> Cells.NumberFormat = "0.00%"
>
> --
> Best Regards,
>
> Luke M
> "mr-tom" <mrtom(a)discussions.microsoft.com> wrote in message
> news:736FA514-2E67-4DDB-8E71-79CDB31C9559(a)microsoft.com...
> > 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.
>
>
> .
>
 | 
Pages: 1
Prev: Userform Import problem
Next: Why is hyperlink staying imbedded when I insert rows into Excel?