Why is it that a cell should format data differently then the cells above it?
When I cut and paste value there shouldnt be any formatting, right? And when
I look at the data from "Format" there is nothing there, however, if you look
at the list you can plainly see that the data does not line up. It waves and
it misses with my VB code. I have to take the first "good" data and drag it
down. What gives? Is there a fix for this? And does this happen in all the
versions of Excel? I'm in 2000.

Thanks for any reply to this.

On Tue, 13 Nov 2007 08:58:05 -0800, pgarcia
wrote:

Why is it that a cell should format data differently then the cells above it?
When I cut and paste value there shouldn’t be any formatting, right? And when
I look at the data from "Format" there is nothing there, however, if you look
at the list you can plainly see that the data does not line up. It waves and
it misses with my VB code. I have to take the first "good" data and drag it
down. What gives? Is there a fix for this? And does this happen in all the
versions of Excel? I'm in 2000.

Thanks for any reply to this.

Since you gave no examples, one can only speculate. But there are any number
of ways this can happen. One common issue is that your data is variously being
interpreted by Excel as number, date or text.

This frequently occurs when users are unaware as to how Excel interprets input.

If you are interested in possible solutions, examples of your data, and code,
might be helpful.
--ron

Cut and paste takes the cell and the formatting. That is the way it has
always been. You can copy and paste special | values which does not change
formatting but cut and paste has no such option.
--
HTH...

Jim Thomlinson


"pgarcia" wrote:

Why is it that a cell should format data differently then the cells above it?
When I cut and paste value there shouldnt be any formatting, right? And when
I look at the data from "Format" there is nothing there, however, if you look
at the list you can plainly see that the data does not line up. It waves and
it misses with my VB code. I have to take the first "good" data and drag it
down. What gives? Is there a fix for this? And does this happen in all the
versions of Excel? I'm in 2000.

Thanks for any reply to this.

My gripe is lousy subject lines with no real explanation or examples and
sample code.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"pgarcia" wrote in message
...
Why is it that a cell should format data differently then the cells above
it?
When I cut and paste value there shouldnt be any formatting, right? And
when
I look at the data from "Format" there is nothing there, however, if you
look
at the list you can plainly see that the data does not line up. It waves
and
it misses with my VB code. I have to take the first "good" data and drag
it
down. What gives? Is there a fix for this? And does this happen in all the
versions of Excel? I'm in 2000.

Thanks for any reply to this.