Date to Text

[giacomo]

How do I convert a date to a text string? I don't want to change the format, I want to change the actual cell value
e.g. change value in cell A1 from 37288 to "2/1/02"

Thanks!
giacomo

[Aladin Akyurek]

On 2002-03-29 12:00, giacomo wrote:
How do I convert a date to a text string? I don't want to change the format, I want to change the actual cell value
e.g. change value in cell A1 from 37288 to "2/1/02"

Thanks!
giacomo

=TEXT(A2,"mm/dd/yy")

[giacomo]

On 2002-03-29 12:02, Aladin Akyurek wrote:

=TEXT(A2,"mm/dd/yy")

Thanks Aladin!

[Jack in the UK]

Hi ==

will the text function not work

say example
=text(anycell,"dddd mmmm yyyy")

format as you need

you past akes for "2/1/02"
so try:
=text(anycell,"dd/mm/yy")

On 2002-03-29 12:00, giacomo wrote:
How do I convert a date to a text string? I don't want to change the format, I want to change the actual cell value
e.g. change value in cell A1 from 37288 to "2/1/02"

Thanks!
giacomo

[Jack in the UK]

for my great friend Aladin sorry mate i have answered this post just behind you so not really the done think

please except sorry on that one not intentional i assure you

Take care mate