| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Stop date conversion in Excel when pasting
When you type in 5/2, I know Excell will automatically convert it to 02-May.
I know I can change the formatting of the cell, up to even using a mask. How do I get content I paste (i.e. from a site displaying data in a grid format), to NOT convert fractions to dates? Changing the content of the data from a website is not an option. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Stop date conversion in Excel when pasting
Perhaps try pre-formatting the cell(s) / col as Text before copy pasting
(via: Format Cells Number tab Text OK) -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Stephanie" wrote in message ... When you type in 5/2, I know Excell will automatically convert it to 02-May. I know I can change the formatting of the cell, up to even using a mask. How do I get content I paste (i.e. from a site displaying data in a grid format), to NOT convert fractions to dates? Changing the content of the data from a website is not an option. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Stop date conversion in Excel when pasting
Pre-formatting the cells did not work. I had tried that. I guess the
"pasting" overrides the cell format. "Max" wrote: Perhaps try pre-formatting the cell(s) / col as Text before copy pasting (via: Format Cells Number tab Text OK) -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Stephanie" wrote in message ... When you type in 5/2, I know Excell will automatically convert it to 02-May. I know I can change the formatting of the cell, up to even using a mask. How do I get content I paste (i.e. from a site displaying data in a grid format), to NOT convert fractions to dates? Changing the content of the data from a website is not an option. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Stop date conversion in Excel when pasting
"Stephanie" wrote
Pre-formatting the cells did not work. I had tried that. I guess the "pasting" overrides the cell format. How about paste special text ? -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- |
|
#5
|
|||
|
|||
|
Quote:
Is there any way of just preventing the date formatting? MS can't be that stupid. Last edited by amdaman : February 20th 11 at 07:58 PM Reason: improper formatting |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Stop excel from dropping the 0 in the beginning of a number? | Setting up and Configuration of Excel | |||
| date conversion after pasting | Excel Worksheet Functions | |||
| Text, Number and Date formats excel 2003 driving experienced user | Excel Discussion (Misc queries) | |||
| How do I stop today() from updating date on saved spreadsheets? | Excel Discussion (Misc queries) | |||
| Creating a Date Selector in Excel VBA? | Excel Discussion (Misc queries) | |||
Linear Mode
