Re: Getting Excel to not try to coerce numbers to Date
From: Tom Ogilvy (twogilvy_at_msn.com)
Date: 07/20/04
- Next message: aburnikel: "Outlook Signature after Attachment"
- Previous message: Tom Ogilvy: "Re: Find & Replace w/ Name Changes"
- In reply to: R Avery: "Re: Getting Excel to not try to coerce numbers to Date"
- Next in thread: anonymous_at_discussions.microsoft.com: "Getting Excel to not try to coerce numbers to Date"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 20 Jul 2004 17:37:26 -0400
That is what I am saying.
if opening a text file, the import wizard allows you to specify a column as
Text, so you could specify all your columns as text.
-- Regards, Tom Ogilvy "R Avery" <ravery74@yahoo.co.uk> wrote in message news:%23CmL4ypbEHA.1152@TK2MSFTNGP09.phx.gbl... > These are two suggestions that I follow (by necessity) all the time. > The reason why I would like this is because I often open up a text file > from Excel and many of the "1 - 30" or "2 - 5" are in random cells and i > do not wish to format everything as text. > > Are you saying that there is no way to force Excel not to coerce these > strings to Dates? > > > Tom Ogilvy wrote: > > Format the cell as text before you make the entry. > > > > or > > > > preceded the value with a single quote > > > > '1-30 > >
- Next message: aburnikel: "Outlook Signature after Attachment"
- Previous message: Tom Ogilvy: "Re: Find & Replace w/ Name Changes"
- In reply to: R Avery: "Re: Getting Excel to not try to coerce numbers to Date"
- Next in thread: anonymous_at_discussions.microsoft.com: "Getting Excel to not try to coerce numbers to Date"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
