Reverse of the value() function

[x-amount]

Is there a way of grabbing the value of a field (in these example they are date fields), as displayed, as text?

I'm trying to sort out some us to uk date formats, and having entries as 01/31/05 along with 1/31/05 confuse the issue somewhat

 

[SteveO59L]

Try the Text() function

 

[barry houdini]

Don't know if this is any help to you but this is a formula I've posted before to convert US to UK dates, should work whatever the format. Assumes your date in A1

=IF(A1="","",IF(ISTEXT(A1),(MID(A1,FIND("/",A1)+1,FIND("/",A1,FIND("/",A1)+1)-FIND("/",A1))&LEFT(A1,FIND("/",A1))&RIGHT(A1,2))+0,DATE(YEAR(A1),DAY(A1),MONTH(A1))))

note: format result cell as date