Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 | |
|
|
Similar Threads | ||||
Thread | Forum | |||
remove mergefields, keep values | Mailmerge | |||
comma delimited text | Mailmerge | |||
Specifying CC: and BCC: Values for Mail Merge to Email | Mailmerge | |||
Linked values | Microsoft Word Help | |||
Can I change mail merge lables to delete-exclude the comma ? ... | Mailmerge |