Search : in
By :

Converting date format

Last answer on Oct 27, 2009 7:58:35 am GMT Raj, on May 29, 2009 1:32:26 pm BST 
 Report this message to moderators

Hello,

I would like to convert the date format to (dd/mm/yyyy) in the attached spreadsheet. Please would you let me knw as to why i'm unable to convert it and also the procedure to convert it going forward cuz i'll have to pull this report every day.

Thanks,
Rajesh

Configuration: Windows XP Internet Explorer 6.0

Best answers for « Converting date format » in :
Verifying date format in PHP ShowVerifying date format in PHP There are several ways to check the format of a date in PHP; the simplest method is to make use regular expressions. To confirm a date format DD/MM/YYYY, where the days and/or month can be given as...
How to convert a video clip in .flv format and vice versa ShowIntroduction Here's a tip for you to simply convert a video clip of (almost) any format to .flv format. This trick will be useful for dealing with the video post or publish your video on the web. How to convert to and from the .flv...
Winmail.dat ShowWinmail.dat Format not supported Solution Option Option 2 Format not supported It may happen that when you receive a message in rtf format same appear as an attachment under Mozilla Thunderbird. This format specific to Microsoft is...
Download Switch File Format Converter Show
Download Koyote Free Video Converter Show
Download Format Factory ShowFormat Factory is an application that allows conversion of various types of media files. It has various characteristics that allow you to customize a lot of stuff like: Convert video formats, audio and picture shows. Repair damaged files. Reduce...
Databases - Using forms ShowUsing forms In order to use databases, the user must be provided with an interface that allows him or her to view data based on certain criteria. There is a tool for this: forms. A form is an interface with components for displaying, entering, or...
MKV format (Matroska Video) ShowMKV format The MKV format (Matroska Video) is an entirely free video format. More precisely, it is a container (hence the name Matroska, in reference to the Russian dolls contained within another) making it possible to contain video (DivX, Xvid,...
Ask your question Reply

1

mubashir aziz, on May 29, 2009 1:45:30 pm BST
  • +3

Just go in Format < Cell < Number > Custom and in right window write dd/mmm/yy ... your format will be changed .......

If still problem then do let me know because may be your Windows Date Format need to be changed .......
Never ashamed to get or give Advise.
Muhammad Mubashir Aziz , Lodhran

   
Reply to mubashir aziz

2

puru, on Oct 27, 2009 7:24:51 am GMT

Hi;

I want change the date as 14-04-2009 to 14-apr-2009.I have lot of colums to be change...can u help me out

   
Reply to puru

3

 mubashir aziz, on Oct 27, 2009 7:58:35 am GMT
  • +1

Just go in Format < Cell < Number > Custom and in right window write dd-mmm-yyyy ... your format will be changed .......

If still problem then do let me know because may be your Windows Date Format need to be changed .......





Never ashamed to get or give Advise.
Muhammad Mubashir Aziz , Lodhran, Pakistan

   
Reply to mubashir aziz
Ask your question Reply
They need your help