Thread: Year as text
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Ten Ten is offline
external usenet poster
 
Posts: 9
Default Year as text

Could you please give an example for say triming " 2003"
to "2003"?

Thx

-----Original Message-----
For 2) you could use the trim function
.