Reference Numbers
Hi
This works well for manually creating a reference number however, I would
like to be able to create the unique reference number automatically when
entering a record in the row.
Can this be done?
Thanks
"Dave" wrote:
Yer
It seems to give the same reference in the next cell down and I have tried
to add a date range into the reference but now it seems to long. I want the
cell to give a reference number only when say the date is added into the row?
Thanks
"Gary''s Student" wrote:
Then use this formula:
=INT((NOW()-39000)*10^7) and format as an integer.
When the formula calculates, just copy the cell and paste/special/value
where the reference number is needed.
--
Gary''s Student - gsnu200840
"Dave" wrote:
Hi
They need to be unique.
Thanks
"Gary''s Student" wrote:
Just use sequential values:
1, 2, 3, .......
--
Gary''s Student - gsnu200840
"DaveKid" wrote:
Hi.
I would like to know if there is a way of creating reference numbers in excel?
Thanks
|