Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
date format...3.1.2010
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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
date format...3.1.2010
Because it is a text string, not a date. You would need to chop the time
element off. -- HTH Bob "backmara" wrote in message ... 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
change date format year to another (e.g., from 1/2/2010 to 1/2/2009) | Excel Discussion (Misc queries) | |||
how can i get the date & time format 2010/02/17 12:05 in excel | Excel Discussion (Misc queries) | |||
Auto date in excell 2010 | Excel Discussion (Misc queries) | |||
2010 date in Excel 2000 | Excel Discussion (Misc queries) |