Thread: format caption
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
newbie newbie is offline
external usenet poster
 
Posts: 137
Default format caption

Hi,

I am using the following code to provide a sequential reference on a userform:
Label5.Caption = 0.0001 + Application.max(Sheets("Notes").Columns(1))
Problem is that if the reference should be 2004.0010, it is displayed on the
form as 2004.001.
Can anyone help me with the syntax to format the caption?
TIA