Quote Numbers in Excel

  • Thread starter Thread starter kitten74
  • Start date Start date
K

kitten74

Hello All,

I'm using Microsoft Excel 2000. Does anyone know if it's possible to
create a document that has one dedicated cell with a number that changes
every time the document is open? (i.e. i'm creating a quotation template,
and would like to have a new quotation number appear every time the template
is open). Maybe using a template is not the way to go, so if you have any
suggestions, I would appreciate them. Thank you.
 
In any cell, enter:

=NOW() and format as General

the value will change whenever the worksheet is openned.
 
Look here:

http://www.mcgimpsey.com/excel/udfs/sequentialnums.html


--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| Hello All,
|
| I'm using Microsoft Excel 2000. Does anyone know if it's possible to
| create a document that has one dedicated cell with a number that changes
| every time the document is open? (i.e. i'm creating a quotation template,
| and would like to have a new quotation number appear every time the template
| is open). Maybe using a template is not the way to go, so if you have any
| suggestions, I would appreciate them. Thank you.
 
While that is true it will change the decimals if opened more than once on
the same day
nor will it be sequential unless opened once each day at the exact same time


--


Regards,


Peo Sjoblom
 
Back
Top