Search : in
By :

How to convert text to date

Last answer on Oct 16, 2009 1:33:41 am BST outofmyleague, on Oct 15, 2009 4:35:59 pm BST 
 Report this message to moderators

Hello,
I hope someone can assist with this problem.
My spreadsheet has a column of dates that import as text, with a column of acct #, and a column of $ amounts.
I need to subtotal the sheet by acct # and month/year.
My first problem is that the date '01/02/2009' looks like this '90102'. I need to get it formatted correctly in order to subtotal.
When I try to format as a date, it changes to '9/8/2146'. I have tried special, custom, function, etc.

Your help is greatly appreciated!

sh

Configuration: Windows XP Internet Explorer 8.0

Best answers for « How to convert text to date » in :
ImageMagick - Manipulate images with command lines ShowImageMagick - Manipulate images with command lines ImageMagick is a powerful command line tool that allows you to manipulate images. The advantage of this tool is that it allows: Automate work on images (this avoids...
[Excel 2003] - IF Function using Dates & Text Show[Excel 2003] - IF Function using Dates & Text Issue Solution Note Issue I'm trying to write a function for a cell which refers to a date in another cell - which if it is between 01/01/1994 and 31/12/1995 the cell will read U16, but...
Converting your PDF file into an Image ShowConverting your PDF file into an Image Universal Document Converter PDF2IMAGE PDF TO IMAGE CONVERTER You could have encountered difficulties to modify PDF docs in the past. Nowadays this is no more trouble as there are several PDF...
Download Snippets Text Database Show
Download MYSQL to Access Database File Converter ShowTo handle Access database is more flexible than to handle MYSQL that is why it would be better to use this latter. To convert your database, Sanmaxi has edited a powerful tool to meet your needs. MYSQL to Access Database File Converter is a...
Download Full Convert Enterprise Show
Hyperlinks ShowIntroduction to anchors Hypertext links or hyperlinks (anchors) are HTML elements that, when clicked on, enable readers to visit a new address. Hyperlinked text is underlined by default. Hyperlinks are what connect web pages to one another. They...
Graphics cards - Video cards Show2D Accelerator Cards A graphics card, sometimes called a graphics adapter, video card or graphics accelerator, is a computer component which converts digital data into a graphical form which can be displayed on a monitor. The initial role of a...
Data transmission - Analogue transmission ShowThe principles of analogue transmission Analogue data transmission consists of sending information over a physical transmission medium in the form of a wave. Data is transmitted via a carrier wave, a simple wave whose only purpose is to transport...
Ask your question Reply

1

 venkat1926, on Oct 16, 2009 1:33:41 am BST

I do not know how the data is entered.
select a date cell and see the formula bar.
if it is m/d/yyyy
then the date is entered correctly. You can format in any form using format numbmer -date.

If the formula bar also shows 90102 then you have to use a formula
I hope this dates is 2nd January 2009 then in that case in another empty cell copy this formula

=(MID(A1,2,2)&"/"&RIGHT(A1,2)&"/0"&LEFT(A1,1))+0

now you format the new entry as any DATE format.

if you carefully study the formula you can do similar formulas in the future

when you use mid, left or right it becomes a text . to convert this into number you use that zero (0) at the end .

   
Reply to venkat1926
Ask your question Reply
They need your help