View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
be_mcwayne be_mcwayne is offline
external usenet poster
 
Posts: 1
Default dates and numbers

I've got to put 2 numbers together. they are in different cells. on is a date
vhile the other is a value e.g.

C4 has 011 and D4 has a date value of 0702 (february 2007)

when I use =D4&C4, i'd like to have 0702011, but I get 3911511

how can I have 0702011