Stop date conversion in Excel when pasting

Posted to microsoft.public.excel.misc

Stephanie

Posts: n/a

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.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Stop excel from dropping the 0 in the beginning of a number?	Rosewood	Setting up and Configuration of Excel	12	April 4th 23 02:12 PM
date conversion after pasting	DC Gringo	Excel Worksheet Functions	2	February 16th 06 06:05 PM
Text, Number and Date formats excel 2003 driving experienced user	E F Bat	Excel Discussion (Misc queries)	1	January 6th 06 07:10 PM
How do I stop today() from updating date on saved spreadsheets?	lionmark	Excel Discussion (Misc queries)	2	January 4th 05 01:03 AM
Creating a Date Selector in Excel VBA?	Mark	Excel Discussion (Misc queries)	0	November 25th 04 10:59 PM

All times are GMT +1. The time now is 04:48 PM.

Menu

About Us