LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 6
Default Stop automatic formatting of cells (number, text, date, etc)

How can I stop Excel2003 from automatically detecting and formatting a cell?

I downloaded some account information as an Excel file (only option
available). The financial institution shows the dates/times as this:
"5/30/2008 2:44:23 PM"

When I open the file, dates and times for March have the exact same format
as the webpage (5/30/2008 2:44:23 PM) and the cell is treated as "general".
But dates in June are displayed as "06/01/2008 20:44" and the cell is treated
as "personalized".

I want the June dates to be treated the same as March dates but nothing
works. If I change the cell format to "text", the content becomes a weird
number: 39453.7503472222. Same if I copy and paste the info into a
pre-formatted text cell. The only thing that works is to manually copy and
paste each value (using F2) but this is highly inefficient.... or doing a
bunch of search and replace in notepad.

Is there a way to prevent Excel from automatically detecting cell formats?
Thank you for any help you can provide


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
Is it possible to get Excel to stop formatting text as a date? PeteeWJ Excel Discussion (Misc queries) 2 May 12th 08 06:28 PM
automatic date formatting Terry Freedman Excel Discussion (Misc queries) 1 October 31st 07 09:40 AM
import /paste -stop automatic conversion of text 05-12345 to date artech Excel Discussion (Misc queries) 1 August 20th 06 09:09 PM
How do I stop automatic conversion of text-to-columns in excel? wraith_oz Excel Discussion (Misc queries) 2 June 13th 06 12:56 AM
How do i stop automatic decimals after number ex 5280.? Frustrated Excel Discussion (Misc queries) 1 March 17th 05 12:47 AM


All times are GMT +1. The time now is 03:17 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"