Home....
Developer Network >> Windows Central >> Windows OS Issues

Excel: Date to Text

Hi. I want to convert an excel cell from date to string. I have found the following:

=TEXT(D3;"d/M/yyyy")

where D3 is the cell containing the date.
Unfortunatelly the returned value is #VALUE. Any ideas?
Regards,
Theodore

PS: I've tested it in Excel XP and 2003.
[306 byte] By [yiannakop] at [2007-11-19 23:33:00]
«« query string
»» How to save uploaded files in database
# 1 Re: Excel: Date to Text
Works for me in Office 2007. Did you format cell D3 to a date format?
PeejAvery at 2007-11-10 3:40:14 >
# 2 Re: Excel: Date to Text
Tried it in Office 2003, and it complained about the formula.

Had to do it as=TEXT(D3,"d/M/yyyy")
But other than that, it worked. With a date in the cell, it formatted it. With a string, it just displayed the string, and with a basic number, it did it's count by days (i.e. 20 displayed '20/1/1900'). Too large of a number gave the #VALUE! error (largest number it supports is 2958466, lowest is 0, but that gives an invalid date of 0/1/1900).

It didn't care for the formatting, just the actual content. Even a Text field of "March 12, 2005" got formatted correctly.
ChaosTheEternal at 2007-11-10 3:41:14 >
# 3 Re: Excel: Date to Text
Thanx for your replies guys. I found the problems. I have Greek regional settings and it seems that this was the problem. dd/mm/yy is not the "greek"format for date, so I had to change it to the greek format (with greek characters). :sick:
yiannakop at 2007-11-10 3:42:14 >
Windows Central
Windows OS Issues

Windows Central

All Classified

Windows Central New Topic

Windows Central Hot Topic