Hi,

Assume A1 contains the bill number which is increased by 1 each time a bill
is produced

i.a range("A1")=range("A1")+1

If B1 contains "BILL NUMBER = " then in C1 put
=CONCATENATE("KHA",TEXT(A1,"0000")

HTH

If A1 contains 123, C1 will be KHA0123


HTH

"bestofcomputer" wrote:

I have a very basic excel calc :
- many fixed texts.
- a table with some data to be filled in many columns.
- one more column with automatic calculations, according to other columns.
So, you see, that is not terrific.
But still, there is something I dont how to do it, could you help me :
- 1 cell is called : "BILL NUMBER = "
- the next cell is blank square, and we are used to fill it manually, by
remembering what was the previous Bill Number we have used previously, and
then we simply increment that number, manually, for each new Bill.
- our format of bill number is = "KHA001", "KHA002", etc...
So, now, is it possible to program that cell, to automatically generate a
bill number in the same format as we already use, but not randomly, and using
numbers following each others, incrementally, increasing of 1 unit, from
previous bill, to the new bill ?
How to do that ?
Auto Calculation ?
Special Function ?
Macro ?
VBA ?
External File ?
Data Base ?
Access OLE ?
What else ?
Thank you so much to help me simplify my daily life...