Thread: Formula concatenating date & text converts date to number
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Wekiva Wekiva is offline
external usenet poster
  
Posts: 2
Default Formula concatenating date & text converts date to number
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


Reply With QuoteReply With Quote