unle chnge dt format 25.01.2011 to 1/25/11 fo

June 25, 2011 at 11:43:49
Specs: Windows XP
unable to chnge date format 25.01.2011 to 1/25/11 by using formula in excel 2003

See More: unle chnge dt format 25.01.2011 to 1/25/11 fo

Report •

July 8, 2011 at 05:59:25
If you are not able to change the date format as you wish - then Insert apostrophe (')at the beginning of the word, then the format stays as you wish.



Report •

July 8, 2011 at 06:43:04
Your date is probably being seen by Excel as text, not as a date.

With 25.01.2011 in A1, try this:


This should return a 5 digit number that represents the date and that can be formatted anyway you want.

Excel stores dates and times internally as numbers, with the integer portion being the date and the decimal portion being the time.

If you want to remove the formula after the conversion to a 5 digit number, try this:

Right Click...Copy...Right Click...PasteSpecial...Values

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Report •

Related Solutions

Ask Question