Using the NOW() function in Excel 2007

[kellem80]

Hi,

I have a form I created for my office that uses Excel 2007. To create a unique ID for each form completed I created a formula that takes the name entered in one cell and concatenates it with the date & time in the adjacent cell. The date and time is calculated using the NOW() function in the cell. so, for example if Bob Smith completed the form today at 2:15 PM, the unique id would be "140903-1415BS" (YYMMDD-HHMMFL) One of my users time is consistently defaulting to 00:00, and I cannot determine why. no, he is not here @ midnight completing it

The only editable (by the user) cell is the name, date cell is locked (formatted as date), unique id cell is locked.

Thoughts on why this occuring and how it can be fixed?

There are currently no other users with this issue.

Thanks!!!

 

[ParamRay]

.
.

Is it possible that the user has automatic calculation mode turned off?

 

[kellem80]

Hi, would that affect just the time and not the date?


There is another calculation in the sheet that is working just fine. (SUM Function)

 

[shg]

You're doing this with a formula or VBA? What formula or code?

 

[kellem80]

You're doing this with a formula or VBA? What formula or code?

Formula in the cell =now()

simple.

when open the sheet, I see 09/3/14 18:08
when it's opened by him it says 09/3/14 00:00
ONLY this one user to my knowledge.

Could he have jacked with his desktop time settings? We don't have access to them, but that's all I can think of unless there is some excel option I'm missing that he may have chosen...( in excel options )

 

[shg]

How does that work for assigning a unique value? It will change every time the sheet calculates.

 

[kellem80]

How does that work for assigning a unique value? It will change every time the sheet calculates.

Unique ID is in a separate cell as mentioned above, the form is either PDF & submitted or printed & submitted-- thus the unique is created from the concatenation combo mentioned above.

My main concern is the time not being correct in the cell with the formula =now() for this one person. I've been using this form this way for 2+ years, he is the only user with issues.

 

[shg]

Color me mystified.

This is your original workbook, the user has made no modifications (as in, you've sent him a clean copy), there is no UDF named NOW() that he has in some add-in, ...

 

[kellem80]

Color me mystified.

This is your original workbook, the user has made no modifications (as in, you've sent him a clean copy), there is no UDF named NOW() that he has in some add-in, ...

You are hearby colored mystified, as am I.

This is my original, created by me book. Pretty sure no add-in, we aren't allowed and the admins have us strictly locked down from trying on our own. The entire worksheet is locked except for cells they need ot enter information into.

I tried, saving off to my desktop, but the lockdown also stayed, I tried copying & pasting the worksheet into a new book, but that was way to much work for the user to have gone thru to try an unlock (knowing user---highly doubt)--but lock down went away, but i couldn't duplicate the time stamp of 0:00

At a loss......