Re: How to display month in 2 digits?

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Another alternative:

="This Month is:"&Text(Today(),"mm")

Regards,
Fred.

"Eric" <Eric@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:DE1530B6-2A95-4C76-AD12-38AF2C111A5F@xxxxxxxxxxxxxxxx
Thank you very much for suggestions.

I need to CONCATENATE a string like that
=CONCATENATE("This Month is: ",month(now())
Could you please give me any suggestions on how to set the format within
concatenate function - String?
This Month is 05
Thank you very much for any suggestions
Eric

"Mike H" wrote:

Hi,

Formatting the cell with a custom format of 00 (That's zero - zero) seems to
work.

Mike

"Eric" wrote:

> Does anyone have any suggestion on how to display month in 2 digits?
> For example, MONTH(NOW()) is 5, but I would like to show 05.
> Thanks in advance for any suggestions
> Eric

.

Relevant Pages

  • Re: Number+1
    ... I had to add a (between CDbl and Format and drop one of the 0's from "Format ... Text String portion. ... using the BeforeInsert event means that the code will only run when a new ... post is 7110001 - no leading zero. ...
    (microsoft.public.access.gettingstarted)
  • Re: onChange problems on fields in order form
    ... whole number greater than zero") and let them fix it however they ... On-screen hints regarding format can help. ... If you want to test that a string meets certain criteria, ...
    (comp.lang.javascript)
  • Re: Timestamp to a string
    ... > concatenate a date string" which I think we can see it isn't. ... > of a date which doesn't mistake some legitimate filename for your ... I want to give an option of specifying the timestamp format to ...
    (comp.lang.java.programmer)
  • Re: Appending sequencial numbers into a table ...
    ... number entered is less or equal to 9, put a 0 (zero) before the number. ... Just use the Format() function to format the string. ... On that form will be 3 radio buttons; ...
    (microsoft.public.access.formscoding)
  • Re: Square Peg in a Round Hole
    ... MsgBox "Please enter valid StartDate." ... will take a valid date, then, by using the Format function, format it ... string into a date variable. ... The *only* time you need to format the date, is when you concatenate it ...
    (microsoft.public.access.queries)