Thread: Paste the value of the format into a new cell
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
 
Posts: n/a
Default Paste the value of the format into a new cell
cell1
value: 1/1/2006
format: jan '06

cell2
value: jan '06 (basically, cell1's format)
format: don't matter

I need to copy cell1 into cell2 with the above parameters.

Reply With QuoteReply With Quote