date format...3.1.2010

's Computer Specifications

Hi all
Excamble:
In the cell: 3.1.2010, formula bar looks--> 3.1.2010 9:21:48 AM. Cell format
is general, why?

How I change this to 3.1.2010?

's Computer Specifications

Because it is a text string, not a date. You would need to chop the time
element off.

--

HTH

Bob

"backmara" <(E-Mail Removed)> wrote in message
news:BACB4AED-BA24-4F51-8757-(E-Mail Removed)...
> Hi all
> Excamble:
> In the cell: 3.1.2010, formula bar looks--> 3.1.2010 9:21:48 AM. Cell
> format
> is general, why?
>
> How I change this to 3.1.2010?

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Convert 24/03/2010 date into 03/24/2010 date format	Nitesh	Microsoft Excel Programming	3	5th Jun 2010 10:44 AM
How to Convert 24/03/2010 as text into 03/24/2010 date format	Nitesh	Microsoft Excel Worksheet Functions	2	5th Jun 2010 10:34 AM
how can i get the date & time format 2010/02/17 12:05 in excel	NarenSelva	Microsoft Excel Misc	2	2nd Mar 2010 08:56 AM
Format a Date Text Box As 2010-02-28	GeyikBaba	Microsoft Access Forms	3	20th Feb 2010 10:14 PM
code to convert date from TEXT format (03-02) to DATE format (200203)	Gauthier	Microsoft Excel Programming	0	22nd Sep 2004 03:26 PM