Would there be a way to have XL2K allow user to copy a cell's result but
paste it without dollar sign and comma?

What I mean is that cell K2 shows result of, say, $5,496.64 with formula of
=SUM(J3:J65506)

Is there a way to get it to make paste show up as the basic number, also
without any of the cell formatting, so that result is

5496.64

instead of $5,496.64?


Thanks! :oD

Copy then pastespecial with just values.
--
JNW


"StargateFanFromWork" wrote:

Would there be a way to have XL2K allow user to copy a cell's result but
paste it without dollar sign and comma?

What I mean is that cell K2 shows result of, say, $5,496.64 with formula of
=SUM(J3:J65506)

Is there a way to get it to make paste show up as the basic number, also
without any of the cell formatting, so that result is

5496.64

instead of $5,496.64?


Thanks! :oD

Edit=Paste special and select values.

--
Regards,
Tom Ogilvy


"StargateFanFromWork" wrote:

Would there be a way to have XL2K allow user to copy a cell's result but
paste it without dollar sign and comma?

What I mean is that cell K2 shows result of, say, $5,496.64 with formula of
=SUM(J3:J65506)

Is there a way to get it to make paste show up as the basic number, also
without any of the cell formatting, so that result is

5496.64

instead of $5,496.64?


Thanks! :oD

"Tom Ogilvy" wrote in message
...
Edit=Paste special and select values.

I'm sorry. I wasn't clear. I need a vb solution which is why I posted to
this ng <g, and the app I'm copying into doesn't have paste special. Sorry
'bout that.

So I'd need the vb code to hopefully copy and remove the $ and , from the
value so that when I paste to another application, I get just the basic
number.
i.e., in my example below, I'd take the result of the formula
=SUM(J3:J65506) of, say,

$15,278.34

and get a paste of

15278.34

The application I'm pasting into is a custom-built one where I work and it
doesn't accept the $ sign and comma in numbers like $15,278.34. It would
save me time to have something like this, so here's hoping! <g

Thanks! :oD

--
Regards,
Tom Ogilvy


"StargateFanFromWork" wrote:

Would there be a way to have XL2K allow user to copy a cell's result but
paste it without dollar sign and comma?

What I mean is that cell K2 shows result of, say, $5,496.64 with formula
of
=SUM(J3:J65506)

Is there a way to get it to make paste show up as the basic number, also
without any of the cell formatting, so that result is

5496.64

instead of $5,496.64?


Thanks! :oD

Does the lack of answer mean this is not possible?

Cheers. :oD


"StargateFanFromWork" wrote in message
...
"Tom Ogilvy" wrote in message
...
Edit=Paste special and select values.

I'm sorry. I wasn't clear. I need a vb solution which is why I posted to
this ng <g, and the app I'm copying into doesn't have paste special.
Sorry 'bout that.

So I'd need the vb code to hopefully copy and remove the $ and , from the
value so that when I paste to another application, I get just the basic
number.
i.e., in my example below, I'd take the result of the formula
=SUM(J3:J65506) of, say,

$15,278.34

and get a paste of

15278.34

The application I'm pasting into is a custom-built one where I work and it
doesn't accept the $ sign and comma in numbers like $15,278.34. It would
save me time to have something like this, so here's hoping! <g

Thanks! :oD

--
Regards,
Tom Ogilvy


"StargateFanFromWork" wrote:

Would there be a way to have XL2K allow user to copy a cell's result but
paste it without dollar sign and comma?

What I mean is that cell K2 shows result of, say, $5,496.64 with formula
of
=SUM(J3:J65506)

Is there a way to get it to make paste show up as the basic number, also
without any of the cell formatting, so that result is

5496.64

instead of $5,496.64?


Thanks! :oD

"StargateFanFromWork" wrote in message
...
Does the lack of answer mean this is not possible?

Cheers. :oD

Again, thanks for the responses so far, but I'm working out of XL2K and into
another application. The amount in the formula comes from XL2K but I need
it to copy the amount without the $ and , so that when I go into the other
application, I get the desired results.

Perhaps behind-the-scenes, XL2K can copy the cell and paste it virtually
somewhere, strip the $ and , and then copy that to the clipboard?? Then I
could just paste straight from the clipboard in the desired format. Again,
I haven't a clue how to do this, but perhaps someone here might know a
possible workaround??

Any suggestions welcome on how to do this.

Thanks. :oD

"StargateFanFromWork" wrote in message
...
"Tom Ogilvy" wrote in message
...
Edit=Paste special and select values.

I'm sorry. I wasn't clear. I need a vb solution which is why I posted
to this ng <g, and the app I'm copying into doesn't have paste special.
Sorry 'bout that.

So I'd need the vb code to hopefully copy and remove the $ and , from the
value so that when I paste to another application, I get just the basic
number.
i.e., in my example below, I'd take the result of the formula
=SUM(J3:J65506) of, say,

$15,278.34

and get a paste of

15278.34

The application I'm pasting into is a custom-built one where I work and
it doesn't accept the $ sign and comma in numbers like $15,278.34. It
would save me time to have something like this, so here's hoping! <g

Thanks! :oD

--
Regards,
Tom Ogilvy


"StargateFanFromWork" wrote:

Would there be a way to have XL2K allow user to copy a cell's result
but
paste it without dollar sign and comma?

What I mean is that cell K2 shows result of, say, $5,496.64 with
formula of
=SUM(J3:J65506)

Is there a way to get it to make paste show up as the basic number,
also
without any of the cell formatting, so that result is

5496.64

instead of $5,496.64?


Thanks! :oD

One possible solution:

Public Sub CopyUnformatted()
Dim vArr As Variant
Dim i As Long
Application.ScreenUpdating = False
With Selection
ReDim vArr(1 To .Count)
For i = 1 To .Count
vArr(i) = .Cells(i).NumberFormat
Next i
.NumberFormat = "General"
.Copy
For i = 1 To .Count
.Cells(i).NumberFormat = vArr(i)
Next i
End With
Application.ScreenUpdating = True
End Sub


In article ,
"StargateFanFromWork" wrote:

Perhaps behind-the-scenes, XL2K can copy the cell and paste it virtually
somewhere, strip the $ and , and then copy that to the clipboard?? Then I
could just paste straight from the clipboard in the desired format. Again,
I haven't a clue how to do this, but perhaps someone here might know a
possible workaround??