| Home | Forums | Reviews | Articles | Register |
 |
| Thread Tools | Rate Thread |
|
Guest
Posts: n/a
|
Hi! I'm pasting some data from Web into Excel tables. But unfortunetlly, Excel transforms text '2/10' into date 'october 2'. How to prevent this from happening. Please help me, because I looked everywere but no luck  -- arnold_charming ------------------------------------------------------------------------ arnold_charming's Profile: http://www.excelforum.com/member.php...o&userid=29350 View this thread: http://www.excelforum.com/showthread...hreadid=490588 |
|
|
|
|||
|
|
| |
|
Guest
Posts: n/a
|
Format the cell. It is currently set to mmmm d. If you wish to retain the
2/10 fromat change it to d/mm. -- Ian -- "arnold_charming" <(E-Mail Removed)> wrote in message news:(E-Mail Removed)... > > Hi! > > I'm pasting some data from Web into Excel tables. But unfortunetlly, > Excel transforms text '2/10' into date 'october 2'. How to prevent this > from happening. Please help me, because I looked everywere but no luck > > > > -- > arnold_charming > ------------------------------------------------------------------------ > arnold_charming's Profile: > http://www.excelforum.com/member.php...o&userid=29350 > View this thread: http://www.excelforum.com/showthread...hreadid=490588 > |
|
|
|
|
|||
|
Guest
Posts: n/a
|
format the cells as text before you paste the values in.
-- Greetings from New Zealand Bill K "arnold_charming" <(E-Mail Removed)> wrote in message news:(E-Mail Removed)... > > Hi! > > I'm pasting some data from Web into Excel tables. But unfortunetlly, > Excel transforms text '2/10' into date 'october 2'. How to prevent this > from happening. Please help me, because I looked everywere but no luck > > > > -- > arnold_charming > ------------------------------------------------------------------------ > arnold_charming's Profile: > http://www.excelforum.com/member.php...o&userid=29350 > View this thread: http://www.excelforum.com/showthread...hreadid=490588 > |
|
|
|
|
|||
|
|
| |
|
| Thread Tools | |
| Rate This Thread | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| import /paste -stop automatic conversion of text 05-12345 to date | =?Utf-8?B?YXJ0ZWNo?= | Microsoft Excel Misc | 1 | 20th Aug 2006 09:09 PM |
| automatic date conversion | =?Utf-8?B?VmluY2U=?= | Microsoft Excel Crashes | 0 | 7th Jul 2006 04:37 AM |
| Stop Automatic Date Conversion | Jerry Baker | Microsoft Excel Discussion | 1 | 13th Oct 2005 11:07 PM |
| import csv without automatic date conversion | =?Utf-8?B?c2hpbnRh?= | Microsoft Excel Misc | 1 | 10th May 2005 04:28 PM |
| Turn off automatic date conversion? | Geoff Offermann | Microsoft Excel Misc | 2 | 10th Oct 2003 06:29 PM |
