Flux rss
Search : in
By : Relevance Date Username
Statut : Not resolved

Date format in excel.

munkee, on Saturday 26 July 2008 à 00:07:23
Hello again,

Is there a way to make excel read fields left padded with a 0.


For example I have a program that only reads date format like this yymmdd, so when I open the csv file in excel it reads 080725 as 80725 instead.

Then when I save any changes it saves 80725 instead.

Thank you for any input.
Configuration: Windows 2000
Firefox 2.0.0.16
Reply to munkee  Report this message to moderators Go to last message

1


  • This message seems useful, vote!
  • Report this message to moderators
 roostertail, on Thursday 6 November 2008 à 15:21:18
It's quite simple actually. Under the "Format Cells"menu, click "Custom" and then add a new formatting with 6 zeros "000000". Once set up, you can use this new custom formatting each time needed.
   
Reply to roostertail
Ask your question Reply

Résultats pour Date format in excel.

Changin format of date in excel Hello, I have an excel sheet which has lots of cells in a column with the date format as - day month date time year & I wish to convert that to dd/mm/yy. How can I do that, pls help. eg - I need to convert "sat Jun 29 00:00:00 PST 1996" to "29/06/96".... en.kioskea.net/forum/affich-28689-changin-format-of-date-in-excel
Custom date format Hello, i need to change the format of dates in excel to read as 1st September 2008 2nd September 2008 and so on en.kioskea.net/forum/affich-26734-custom-date-format
Excel Date Format (Solved) Hello, when users enter a date in excel using this format 12.1.2008, i need the cell to automatically change the format to 12-Jan-08 thanks, moses en.kioskea.net/forum/affich-19164-excel-date-format

Résultats pour Date format in excel.

Excel tips : How to insert date In an Excel cellExcel tips : How to insert date In an Excel cell Below are some tips on how to insert date and time in an excel cell for a specific purpose:- To insert current date, press “CTRL”+ “;” in the chosen cell. To insert current... en.kioskea.net/faq/sujet-313-excel-tips-how-to-insert-date-in-an-excel-cell
Starting with visual basicStarting with visual basic Visual Basic is a programming tool designed by Microsoft for its Component Object Model (COM). This tool can be used to create applications for windows, web, mobile devices etc.The latest version of Visual basic... en.kioskea.net/faq/sujet-305-starting-with-visual-basic
1 2 3 Next

Résultats pour Date format in excel.

DATE FORMATTING IN dd/mm/yyyyHello, i have got dates typed in the format following 01.08.98 and i want to change it to 01/08/1998 format.i tried applying the format we have in excel format cell date format but nothing is happening.please help me on this. en.kioskea.net/forum/affich-22133-date-formatting-in-dd-mm-yyyy
Change Date Format in XPHello, The system default short date format is: dd-MM-yyyy. We have an application that runs with the date format in: dd/MM/yyyy. Is there any method (e.g. batch) so that we can change the date format temporary when launch the application and then... en.kioskea.net/forum/affich-5052-change-date-format-in-xp
HOW TO COPY THE DATA FROM EXCEL BY USING MACRHello, My query is, How to copy Data from excel sheet in to new excel file by useing Macro. Regards, Kris en.kioskea.net/forum/affich-31122-how-to-copy-the-data-from-excel-by-using-macr
1 2 3 Next

Résultats pour Date format in excel.

Download Excel ViewerWith Excel Viewer, you can open, view, and print Excel workbooks, even if you don't have Excel installed. You can also copy data from Excel Viewer to another program. en.kioskea.net/telecharger/telecharger-52-excel-viewer
Download LiveProject Free Project ViewerLiveProject is an application of visualization of file mpp free. LiveProject introduces no degradation of the file mpp during exportation in format Excel or html. With LiveProject, you will be able to print your own documents. The use of LiveProject... en.kioskea.net/telecharger/telecharger-860-liveproject-free-project-viewer
1 2 3 Next

Résultats pour Date format in excel.

Databases - Using 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 selecting data.... en.kioskea.net/bdd/bddform.php3
Spreadsheets - Data Entry A cell of a worksheet can contain a value or be empty. The value of a cell has two essential characteristics: a type, which means the intrinsic type of the data. There are generally three types of values: numeric values, for example 3.1415927, 58%,... en.kioskea.net/tableur/tabsaisie.php3
Data transmission - Digital transmission Digital transmission is the sending of information over a physical communications media in the form of digital signals. Analogue signals must therefore be digitised first before being transmitted. However, as digital information cannot be sent... en.kioskea.net/transmission/transnum.php3
1 2 3 Next