hi all
the attached Template excel file has cell called "Invoice no."
I wan that cell to be automatically updated to give each invoice unique number
like S1000 and it ill be S1001 for the next invoice but i have no idea how this will be done
I tried to set it to be data and time using
=now() but the problem is that it shown by this format 7/31/14 10:59
i tried to covert it to this format 1407311059 but I fail
so please anyone can help !
the attached Template excel file has cell called "Invoice no."
I wan that cell to be automatically updated to give each invoice unique number
like S1000 and it ill be S1001 for the next invoice but i have no idea how this will be done
I tried to set it to be data and time using
=now() but the problem is that it shown by this format 7/31/14 10:59
i tried to covert it to this format 1407311059 but I fail
so please anyone can help !