 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Worksheet Functions / October 2006sequential number code
I am using the following function to create some sequential numbering: =TEXT(ROW(A1), "W2-0000") The problem I am having is when I try to change the W2 to H (or some other letters) the formula no longer works and I get #VALUE!. Does anyone know what might cause this and how to correct it? It seems like changing only certain letters create the error. Certain letters correspond to specific formatting options. H stand for hour. Why not just remove the letters something like this... ="W2-" & TEXT(ROW(A1), "0000")  SignatureHTH... Jim Thomlinson > I am using the following function to create some sequential numbering: > [quoted text clipped - 5 lines] > Does anyone know what might cause this and how to correct it? It seems like > changing only certain letters create the error. Interesting. Replacing W with A, C, works but replacing W with B, D doesn't. Wonder if that pattern repeats for the entire alphabet. Dave SignatureBrevity is the soul of wit. > I am using the following function to create some sequential numbering: > [quoted text clipped - 5 lines] > Does anyone know what might cause this and how to correct it? It seems like > changing only certain letters create the error. D is Day. B is ??? SignatureHTH... Jim Thomlinson > Interesting. > [quoted text clipped - 12 lines] > > Does anyone know what might cause this and how to correct it? It seems like > > changing only certain letters create the error. I don't know. This is the first time I've seen this... SignatureBrevity is the soul of wit. > D is Day. B is ??? > [quoted text clipped - 14 lines] > > > Does anyone know what might cause this and how to correct it? It seems like > > > changing only certain letters create the error. =TEXT(ROW(A1),"\H-0000") SignatureHTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) > I am using the following function to create some sequential numbering: > [quoted text clipped - 5 lines] > Does anyone know what might cause this and how to correct it? It seems like > changing only certain letters create the error. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.