When I use the NOW() function in VBA I get the current format:

3/20/2007 1:20:46 PM

How do I change this to get the following:

3/20/2007 1320

I need to get rid of the colon and lose the seconds.

Actually it would be interesting to know how to extract the formatting
imbedded int that as well. Is their a format property?

Thanks

EM

I believe Now() returns the date and time using the format specified in your
computers regional settings. You can use the Format method to display
Now()'s return value in a different format.

Format(Now(), "mm/dd/yyyy hhmm")


--

Hope that helps.

Vergel Adriano


"ExcelMonkey" wrote:

> When I use the NOW() function in VBA I get the current format:
>
> 3/20/2007 1:20:46 PM
>
> How do I change this to get the following:
>
> 3/20/2007 1320
>
> I need to get rid of the colon and lose the seconds.
>
> Actually it would be interesting to know how to extract the formatting
> imbedded int that as well. Is their a format property?
>
> Thanks
>
> EM

Format Custom as

m/dd/yyyy hhmm

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"ExcelMonkey" <(E-Mail Removed)> wrote in message news:F2E1BD32-8F7C-493A-8213-(E-Mail Removed)...
| When I use the NOW() function in VBA I get the current format:
|
| 3/20/2007 1:20:46 PM
|
| How do I change this to get the following:
|
| 3/20/2007 1320
|
| I need to get rid of the colon and lose the seconds.
|
| Actually it would be interesting to know how to extract the formatting
| imbedded int that as well. Is their a format property?
|
| Thanks
|
| EM

Format(Now(), "mm/dd/yyyy hhmm")

Ed

On Mar 20, 12:20 pm, ExcelMonkey
<ExcelMon...@discussions.microsoft.com> wrote:
> When I use the NOW() function in VBA I get the current format:
>
> 3/20/2007 1:20:46 PM
>
> How do I change this to get the following:
>
> 3/20/2007 1320
>
> I need to get rid of the colon and lose the seconds.
>
> Actually it would be interesting to know how to extract the formatting
> imbedded int that as well. Is their a format property?
>
> Thanks
>
> EM

Format(Now(), "m/d/yyyy hmm")

Suppose putting =Now() in an unformatted cell shows the imbedded
format. For me it is m/d/yyyy h:mm.

Hth,
Merjet

Thanks all.

EM

"merjet" wrote:

> Format(Now(), "m/d/yyyy hmm")
>
> Suppose putting =Now() in an unformatted cell shows the imbedded
> format. For me it is m/d/yyyy h:mm.
>
> Hth,
> Merjet
>
>
>
>