ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Excel Reader : How to paste as numbers to Quattro Pro ? (https://www.excelbanter.com/excel-discussion-misc-queries/156700-excel-reader-how-paste-numbers-quattro-pro.html)

Mr. Low

Excel Reader : How to paste as numbers to Quattro Pro ?
 
Dear Sir,

I noticed that when I paste reports generated in Excel Reader to Quattro Pro
Worksheet, the numbers become text.

Usually I need to use +value () to convert it back.

May I know is there a way to overcome this problem ?

Thanks

Low


--
A36B58K641

joel

Excel Reader : How to paste as numbers to Quattro Pro ?
 
Two thing you can try.
1) After you paste sell if the the fromat box appears on the screen. Change
the selection in the box to Source formatting.
2) Format the destnation page to number. Then do your copy and paste.

"Mr. Low" wrote:

Dear Sir,

I noticed that when I paste reports generated in Excel Reader to Quattro Pro
Worksheet, the numbers become text.

Usually I need to use +value () to convert it back.

May I know is there a way to overcome this problem ?

Thanks

Low


--
A36B58K641



All times are GMT +1. The time now is 12:03 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com