Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Turn off automatic date formatting
I'm pasting data into an Excel spreadsheet which is formatted as W-L-T, i.e.
1-0-2. Excel very handily insists that I'm trying to paste in a date, even though most of the values clearly aren't valid dates (which values Excel leaves alone). Other than writing a formula to figure out where Excel has outsmarted itself, is there a way to turn this "feature" off? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Turn off automatic date formatting
Format the cells as Text.
You can do this by doing a right click on a cell or an entire column. Then choose fomat cells. In the Category choose Text Should work "jwt" wrote: I'm pasting data into an Excel spreadsheet which is formatted as W-L-T, i.e. 1-0-2. Excel very handily insists that I'm trying to paste in a date, even though most of the values clearly aren't valid dates (which values Excel leaves alone). Other than writing a formula to figure out where Excel has outsmarted itself, is there a way to turn this "feature" off? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Turn off automatic date formatting
Thanks but this doesn't work. When I make the format text teh entries that
Excel thought were dates gets formatted as teh numerical value. "Mike" wrote: Format the cells as Text. You can do this by doing a right click on a cell or an entire column. Then choose fomat cells. In the Category choose Text Should work "jwt" wrote: I'm pasting data into an Excel spreadsheet which is formatted as W-L-T, i.e. 1-0-2. Excel very handily insists that I'm trying to paste in a date, even though most of the values clearly aren't valid dates (which values Excel leaves alone). Other than writing a formula to figure out where Excel has outsmarted itself, is there a way to turn this "feature" off? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Turn off automatic date formatting
I think what Mike missed was to pre-format the cells as Text BEFORE your paste.
That usually works. Gord Dibben MS Excel MVP On Sat, 29 Sep 2007 18:38:00 -0700, jwt wrote: Thanks but this doesn't work. When I make the format text teh entries that Excel thought were dates gets formatted as teh numerical value. "Mike" wrote: Format the cells as Text. You can do this by doing a right click on a cell or an entire column. Then choose fomat cells. In the Category choose Text Should work "jwt" wrote: I'm pasting data into an Excel spreadsheet which is formatted as W-L-T, i.e. 1-0-2. Excel very handily insists that I'm trying to paste in a date, even though most of the values clearly aren't valid dates (which values Excel leaves alone). Other than writing a formula to figure out where Excel has outsmarted itself, is there a way to turn this "feature" off? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Turn off automatic date formatting
Also depends on where the data came from, if it came from
Excel as a number the format will also be copied, overriding the text format. But as Gord indicates you cannot change the format from number to text, or from text to number for the data that is already entered. "Gord Dibben" <gorddibbATshawDOTca wrote in message ... I think what Mike missed was to pre-format the cells as Text BEFORE your paste. That usually works. Gord Dibben MS Excel MVP On Sat, 29 Sep 2007 18:38:00 -0700, jwt wrote: Thanks but this doesn't work. When I make the format text teh entries that Excel thought were dates gets formatted as teh numerical value. "Mike" wrote: Format the cells as Text. You can do this by doing a right click on a cell or an entire column. Then choose fomat cells. In the Category choose Text Should work "jwt" wrote: I'm pasting data into an Excel spreadsheet which is formatted as W-L-T, i.e. 1-0-2. Excel very handily insists that I'm trying to paste in a date, even though most of the values clearly aren't valid dates (which values Excel leaves alone). Other than writing a formula to figure out where Excel has outsmarted itself, is there a way to turn this "feature" off? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I turn off automatic date function in XL? | Excel Worksheet Functions | |||
Turn off automatic date formatting? | Excel Discussion (Misc queries) | |||
turn off automatic date default | Setting up and Configuration of Excel | |||
Automatic date formatting | Excel Discussion (Misc queries) | |||
How do I disable automatic date formatting in excel? | Excel Discussion (Misc queries) |