Comma Delimiting Values

[Guest]

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!

 

[Jezebel]

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.

 

[Guest]

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]

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.