I have worksheet setup for calculating project estimates and would like to
use a function like "now()" to generate a unique proposal number based on the
date and time the file is created. How do I do this with out having it change
every time the sheet calculates?

ctrl+;<press space barctrl+shift+:


"MSR Mike" wrote:

I have worksheet setup for calculating project estimates and would like to
use a function like "now()" to generate a unique proposal number based on the
date and time the file is created. How do I do this with out having it change
every time the sheet calculates?

Thanks for the reply!

What do those keystroke do?

"Teethless mama" wrote:

ctrl+;<press space barctrl+shift+:


"MSR Mike" wrote:

I have worksheet setup for calculating project estimates and would like to
use a function like "now()" to generate a unique proposal number based on the
date and time the file is created. How do I do this with out having it change
every time the sheet calculates?

They will enter the static date/time in a cell.

Biff

"MSR Mike" wrote in message
...
Thanks for the reply!

What do those keystroke do?

"Teethless mama" wrote:

ctrl+;<press space barctrl+shift+:


"MSR Mike" wrote:

I have worksheet setup for calculating project estimates and would like
to
use a function like "now()" to generate a unique proposal number based
on the
date and time the file is created. How do I do this with out having it
change
every time the sheet calculates?