Re: Prevent excel to auto format and auto apply formula to a cell when opening a file
From: Dave Peterson (ec35720_at_msn.com)
Date: 02/27/04
- Next message: Norman Harker: "Re: Any way to make all references in a cell absolute?"
- Previous message: Alan: "Re: Floor Plan Sketch in Excel"
- In reply to: MikeVince: "Prevent excel to auto format and auto apply formula to a cell when opening a file"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 26 Feb 2004 20:37:48 -0600
Another option:
Rename your .csv file to .txt
file|open
You'll get the wizard and you can specify text for those fields and date (mdy)
for the last.
"MikeVince <" wrote:
>
> Hi,
>
> I have this problem of mine that troubled me for days.
>
> You see, i have a CSV file which has values like :
>
> "3/1","4/2","10-20-2004"
>
> when i open the CSV file using excel, excel will automatically convert
> the values to be like:
>
> 3-1-2004 4-1-2004 10-20-2004
>
> the 10-20-2004 is okay since it is really a date but the 3/1 and 4/2
> are not dates and are not any form of equation.
>
> i just want excel to display them as exactly as seen in the CSV file.
> so i tried to right click on the rows for both 3/1 and 4/2 and selected
> "Format Cells". Inside the "Format Cells", i selected the "text"
> category in the "Number" tab. But when i do that, the value for 3/1
> will become 38047.
> I also tried Edit->Clear->All but still it didnt helped.
>
> do you guys know how to make excel display the CSV value of 3/1 as
> exactly 3/1 ?
>
> please reply to my email if you know --> michaelp@tp.edu.sg
>
> thanks for your time.
>
> ---
> Message posted from http://www.ExcelForum.com/
-- Dave Peterson ec35720@msn.com
- Next message: Norman Harker: "Re: Any way to make all references in a cell absolute?"
- Previous message: Alan: "Re: Floor Plan Sketch in Excel"
- In reply to: MikeVince: "Prevent excel to auto format and auto apply formula to a cell when opening a file"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
