0

I need to create a spreadsheet with the following sequential numbering "0001/2014", I can create the number in reverse "2014/0001" but that is not what I want. Any suggestions would be most appreciated.

Improve this question
1
  • What sequence you're actually talking about? A sequence that runs from "0001/2014" to "9999/2014" or what? You need to clarify your question to make it possible to offer any meaningful advice.
    – zagrimsan
    Nov 27, 2014 at 9:29

1 Answer 1

Reset to default
1 
=TEXT(ROWS($A$1:A1),"0000")&"/2014"

copy down.

Improve this answer
1
  • You could mark this as the answer, then, right? So others will find it too.
    – teylyn
    Nov 27, 2014 at 10:04

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .