Results 1 to 2 of 2
  1. #1
    Silver Lounger
    Join Date
    Dec 2000
    Location
    California, USA
    Posts
    1,758
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Text Function Error (English_XL97_SR2)

    I can not get the VBA code for Text to work although it is supported in VBA.

    An example of the XL formula would be: =Text(A1,"MM DD") where cell A1contained the numeric value of a date such as 09/15/01; B1 would contain the formula.

    Any suggestions?

  2. #2
    Platinum Lounger
    Join Date
    Dec 2000
    Location
    Queanbeyan, New South Wales, Australia
    Posts
    3,730
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Text Function Error (English_XL97_SR2)

    What about the format command?

    FORMAT(#01/01/2001#,"MM DD")

    or

    FORMAT (CELLS(A1),"MM DD")
    Subway Belconnen- home of the Signboard to make you smile. Get (almost) daily updates- follow SubwayBelconnen on Twitter.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •