| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data being corrupted by excels automatic date recognition re-f
Ok, well, try one of the other methods in the other replies.
-- Biff Microsoft Excel MVP "PaddyD." wrote in message ... "T. Valko" wrote: when pasted into a cell (pre-formated as text) OK, pre-format the destination cells *and* instead of doing a paste do a paste specialtext. However!!! If the data being copy/pasted is numeric then it will also get pasted as TEXT but converting text numbers to numeric numbers is a lot easier than dealing with data converted to dates! -- Biff Microsoft Excel MVP Hi Biff, thanks your reply. The problem is i'm pasting in tables and if i past in using Paste SpecialText it only goes into one column. I can't then split this as some of the table fields are open text format and I can't specify a meaningful delimiter... Paddy. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| HI, I want to 5-9 as age group but it comes as 05 sept date forma | New Users to Excel | |||
| date recognition problem | Excel Worksheet Functions | |||
| Automatic copy recognition in columns | Excel Discussion (Misc queries) | |||
| Copying Data forma website | Excel Discussion (Misc queries) | |||
| How do I compare output data from 2 pivot tables in a graph forma. | Charts and Charting in Excel | |||
Threaded Mode
