Formula concatenating date & text converts date to number

  • Thread starter Thread starter Wekiva
  • Start date Start date
W

Wekiva

Using Excel 2003

I have entered the following formula: =today() & " Net"

I want the result to be : 4/7/09 Net , but I keep getting : 39910 Net

Any suggestions?

Thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top