Hello people I am in need of assistance in trying to complete the following formula.
The formula is to consist of text at the start an example been "hello world " then I wanted it to have a space then today's date showing.
I did the following formula ="Hello World " & TODAY() thinking that would be enough but instead I get the following result
Hello World 41933 I know that the numbers is due to excel calculating the date in it's own method.
The question I need answering is how do I do it so that instead of the above it comes out as Hello World 21/10/2014.
Any advice would be grateful and thanks
Bookmarks