Automatically insert today's date in English format?

[kellyfirth]

When I use the function: =TODAY() it inserts today's date but in American format?

I can use: =TEXT(A1,"dd/mm/yyyy")to change this into the format I want but is there a way to make this all occur in just one formula so that I don't end up with 2 cells containing dates?

 

[AkaTrouble]

try this

[FONT=courier new]=TEXT(TODAY(),"dd/mm/yyyy")[/FONT]

 

[kellyfirth]

That worked perfectly, thanks! I couldn't figure out how it'd fit together. Brilliant

 

[Rick Rothstein]

When I use the function: =TODAY() it inserts today's date but in American format?

A date is a date no matter what format it is displayed as. If you don't like the default, just use Cell Formatting to change it.