| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cell formatting when pasting from a non-Office application
Are you able to change a setting in Excel so that any copied text, numbers
maintain the formatting in the destination file (versus the originating - copied from - file)? I know you can do this in Word, but can't find it in Excel. Thanks |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Cell formatting when pasting from a non-Office application
Copy a range
Right clickPasteSpecialAll OR Right clickPasteSpecialFormatsOK followed by PasteSpecialValuesOK. If this post helps click Yes --------------- Jacob Skaria "Nancy S" wrote: Are you able to change a setting in Excel so that any copied text, numbers maintain the formatting in the destination file (versus the originating - copied from - file)? I know you can do this in Word, but can't find it in Excel. Thanks |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Cell formatting when pasting from a non-Office application
For ***Non-Office application ***
PasteSpecialText.. once copied try...DataText to Columns... Most of the time what i do is copy this to a text editor such as NotePad and then copy that to excel...so that excel assumes text and numbers.. If this post helps click Yes --------------- Jacob Skaria "Jacob Skaria" wrote: Copy a range Right clickPasteSpecialAll OR Right clickPasteSpecialFormatsOK followed by PasteSpecialValuesOK. If this post helps click Yes --------------- Jacob Skaria "Nancy S" wrote: Are you able to change a setting in Excel so that any copied text, numbers maintain the formatting in the destination file (versus the originating - copied from - file)? I know you can do this in Word, but can't find it in Excel. Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Office application version does not match. | Excel Discussion (Misc queries) | |||
| How to use Excel.exe without installing Office in VB Application | Setting up and Configuration of Excel | |||
| Pasting into a cell with conditional formatting | Excel Discussion (Misc queries) | |||
| Can I make an order form on an office application? | Excel Discussion (Misc queries) | |||
| lose formatting (border) in excel cell after pasting from word | Excel Discussion (Misc queries) | |||
![Nancy S[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
