Thread: Insert ' sign infront of dates
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Ed Ferrero Ed Ferrero is offline
external usenet poster
  
Posts: 115
Default Insert ' sign infront of dates
Hi,

Format -- Cells...

Number Tab

Custom Format

Enter the next line as the format
"'" d-mm-yy

Ed Ferrero
Microsoft Excel MVP
http://www.edferrero.com


Reply With QuoteReply With Quote