Thread: Simple Question, display only part of a date in Number format
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
DB Explorer
 
Posts: n/a
Default Simple Question, display only part of a date in Number format
Hi

This might be a very simple question to most of you, but I am a novice
user.

If A1 has date in the format 04-Jan-06, then how do I have B1 display
only the first two characters "04" in number format, which means 4?

Cheers
Sunny

Reply With QuoteReply With Quote