Weird cell formatting (sequential numbering and dates)

  • Thread starter Thread starter Juder
  • Start date Start date
J

Juder

I am doing customer receipts and am numbering them like this:

1-F04 (For the first sale in Feb. '04)
2-F04 (For the second sale in Feb. '04), etc.

How in the world can I program a cell to do this? I tried the custo
formatting options, but nothing would work.

Anyone know or have any ideas?

TIA. -Jud
 
Hi
one way:
put the following formula in A2 (as number)
=IF(B2<>"",MAX($A$1:$A1)+1,"")
format this cell with the custom format:
#"-F04"
copy down

this works for February. If you have more months on a sheet you should
provide more details about your actual spreadsheet layout
 
Back
Top