Reply
 
Thread Tools Display Modes
  #1   Report Post  
KC8DCN
 
Posts: n/a
Default Comma Delimiting Values

I have values in Excel that are formatted with a decimal and comma. I need
to copy it over to Word in a table using Paste Special Unformatted Text.
When this happens, though, Word uses the comma as a delimiter and cuts off
digits. Is there a way to copy the values over with a comma and still use
Paste Special??

Thanks!
  #2   Report Post  
Jezebel
 
Posts: n/a
Default

Fix the values in Excel: the underlying values should simply be numbers. The
commas and decimal should simply be formatting appliued to the number; from
your description, the values seem to have been entered as text. You can use
Excel's functions to convert the text to numbers; the import to Word should
then work correctly.


"KC8DCN" wrote in message
...
I have values in Excel that are formatted with a decimal and comma. I need
to copy it over to Word in a table using Paste Special Unformatted Text.
When this happens, though, Word uses the comma as a delimiter and cuts off
digits. Is there a way to copy the values over with a comma and still use
Paste Special??

Thanks!



  #3   Report Post  
KC8DCN
 
Posts: n/a
Default

I tried this and it didn't work....

I used the =value() formula to convert the text to numerical values. It
convereted to a number like 123,456.00. When I copied and pasted the values
into Word using Paste Special Unformatted option, it still only copies in
123; after that, it truncates the number.



"Jezebel" wrote:

Fix the values in Excel: the underlying values should simply be numbers. The
commas and decimal should simply be formatting appliued to the number; from
your description, the values seem to have been entered as text. You can use
Excel's functions to convert the text to numbers; the import to Word should
then work correctly.


"KC8DCN" wrote in message
...
I have values in Excel that are formatted with a decimal and comma. I need
to copy it over to Word in a table using Paste Special Unformatted Text.
When this happens, though, Word uses the comma as a delimiter and cuts off
digits. Is there a way to copy the values over with a comma and still use
Paste Special??

Thanks!




  #4   Report Post  
Jezebel
 
Posts: n/a
Default

There are no numbers 'like' 123,456.00 -- the value is 123456: the
display -- ie the comma and point -- is the default *formatting* in Excel.
Change the format to what you want (ie no thousands separator) and your
problem goes away.


"KC8DCN" wrote in message
...
I tried this and it didn't work....

I used the =value() formula to convert the text to numerical values. It
convereted to a number like 123,456.00. When I copied and pasted the
values
into Word using Paste Special Unformatted option, it still only copies in
123; after that, it truncates the number.



"Jezebel" wrote:

Fix the values in Excel: the underlying values should simply be numbers.
The
commas and decimal should simply be formatting appliued to the number;
from
your description, the values seem to have been entered as text. You can
use
Excel's functions to convert the text to numbers; the import to Word
should
then work correctly.


"KC8DCN" wrote in message
...
I have values in Excel that are formatted with a decimal and comma. I
need
to copy it over to Word in a table using Paste Special Unformatted
Text.
When this happens, though, Word uses the comma as a delimiter and cuts
off
digits. Is there a way to copy the values over with a comma and still
use
Paste Special??

Thanks!






Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
remove mergefields, keep values Jim Zoupas Mailmerge 2 March 15th 05 09:25 AM
comma delimited text Karl Mailmerge 2 January 18th 05 04:14 PM
Specifying CC: and BCC: Values for Mail Merge to Email Mark V Mailmerge 2 November 29th 04 04:55 PM
Linked values WillieWorstel Microsoft Word Help 1 November 26th 04 06:07 PM
Can I change mail merge lables to delete-exclude the comma ? ... Anne-Louise Mailmerge 1 November 25th 04 03:32 PM


All times are GMT +1. The time now is 01:49 PM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"