Search : in
By :

Excel Date formatting problem

Last answer on Sep 22, 2009 3:19:18 pm BST chow70, on Sep 21, 2009 6:52:34 pm BST 
 Report this message to moderators

So here's my problem. I have multipe dates all in one column on one tab/worksheet of an excel workbook. When I try to link to that date on another tab/worksheet within the same workbook,in a formula it comes out formatted as a general format that doesn't look like a date at all. I have the date formatted in mm/dd/yyyy but when I try to recall that date on the following worksheet, it comes out as general. Does anybody know of any function I can use to make it come back out in the original format or am I going to have to figure out some ghetto way that will require multiple steps?? I would appreciate any help.

Thanks

Configuration: Windows XP
Firefox 3.5.3

Best answers for « Excel Date formatting problem » 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...
Excel tips : How to insert date in a cell ShowExcel tips : How to insert date in a 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 time, press CTRL¯+...
Connect a database (MDB) to excel Show[VBA] Connecting a database (MDB) to excel Below is a tips of how to connect an Access database (MDB) in an application excel Add reference Microsoft DAO object librairy X.X In a general module (eg Module1) paste the code below...
Download Data Manager for Excel ShowHave you already thought that your Excel worksheet can be transformed into a true database? Now, it is possible thanks to Data Manager for Excel. Data Manager for Excel is an add-in for Microsoft Excel allowing to transform the worksheets into...
Download Excel-MySQL converter ShowHenceforth with Excel-MySQL Converter, it is not necessary to be a developer to be able to convert Microsoft Excel data into MySQL database or vice versa. This program allows you to convert quickly your data without using other material. Depending...
S/PDIF format ShowS/PDIF format The S/PDIF standard ("Sony/Philips Digital Interface", or SPDIF for short) is a digital audio data transfer format. It is an international standard known as "IEC-958 type II", which defines both hardware specifications (physical...
Introduction - Databases ShowWhat is a database? A database (abbreviated DB) is an entity in which data can be stored in a structured manner, with as little redundancy as possible. Different programs and different users must be able to use this data. Therefore, the concept of...
Spreadsheets - Data Entry ShowCell Content 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...

1

Trowa, on Sep 22, 2009 1:49:05 pm BST

Just format the cells containing the formula in the date format.

Reply to Trowa

2

 chow70, on Sep 22, 2009 3:19:18 pm BST

You can't do it when the link to the cell is imbedded within a formula. For example, when you type this for a formula in a cell

="11-05100-0"&B3

where the cell B3 equals 8/31/09

it comes out looking like

11-05100-040056

when I need it to look like

11-05100-08312009

Anybody have any ideas?

Reply to chow70