Date now Time Now

[Brento]

Hi

I am looking to put in 2 formulas one for date and other for time.

I have Tried =NOW() and tried different cell formating but it doesnt work.

please help?

brent

[socram_06]

Hi...

Try use =TODAY() for the date, and =NOW() for the time...

If =NOW() return no result, try a different format for =TODAY() formula.

Hope it helps...

Marcos.