Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to create a prefix containing text and zero?
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to create a prefix containing text and zero?
Hi Gene
A bit sparse on requirements but here's a guess With part number in A1 ="Part Number 0"&A1 Regards Roger Govier GeneWan wrote: |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to create a prefix containing text and zero?
Hi Roger,
Thanks for the suggestion, I should have been more detailed: I'm trying to achieve creating the prefix so that it will appear along with the number that I key in. Eg. after typing "12" the cell should show SN0012, where "SN00" is my prefix. Appreciated.. :) "Roger Govier" wrote: Hi Gene A bit sparse on requirements but here's a guess With part number in A1 ="Part Number 0"&A1 Regards Roger Govier GeneWan wrote: |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to create a prefix containing text and zero?
Without a macro you can't.
Why not adopt Roger's approach and use a helper column B ="SN00"&A1, or better still with "SN00" in say C1 =$C$1&A1 Rgds On Wed, 23 Nov 2005 02:22:02 -0800, "GeneWan" wrote: Hi Roger, Thanks for the suggestion, I should have been more detailed: I'm trying to achieve creating the prefix so that it will appear along with the number that I key in. Eg. after typing "12" the cell should show SN0012, where "SN00" is my prefix. Appreciated.. :) "Roger Govier" wrote: Hi Gene A bit sparse on requirements but here's a guess With part number in A1 ="Part Number 0"&A1 Regards Roger Govier GeneWan wrote: Richard Buttrey __ |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to create a prefix containing text and zero?
I see..
I was trying to avoid creating an additional column, I was not sure if I could achieve it, but if you suggest otherwise, Roger's approach would be the most straightforward.. it's a shame, coz I could get the "SN" to appear, but I lost the zero that I need. Thanks! "Richard Buttrey" wrote: Without a macro you can't. Why not adopt Roger's approach and use a helper column B ="SN00"&A1, or better still with "SN00" in say C1 =$C$1&A1 Rgds On Wed, 23 Nov 2005 02:22:02 -0800, "GeneWan" wrote: Hi Roger, Thanks for the suggestion, I should have been more detailed: I'm trying to achieve creating the prefix so that it will appear along with the number that I key in. Eg. after typing "12" the cell should show SN0012, where "SN00" is my prefix. Appreciated.. :) "Roger Govier" wrote: Hi Gene A bit sparse on requirements but here's a guess With part number in A1 ="Part Number 0"&A1 Regards Roger Govier GeneWan wrote: Richard Buttrey __ |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to create a prefix containing text and zero?
How about a custom format of "SN00"0
-- HTH RP (remove nothere from the email address if mailing direct) "GeneWan" wrote in message ... I see.. I was trying to avoid creating an additional column, I was not sure if I could achieve it, but if you suggest otherwise, Roger's approach would be the most straightforward.. it's a shame, coz I could get the "SN" to appear, but I lost the zero that I need. Thanks! "Richard Buttrey" wrote: Without a macro you can't. Why not adopt Roger's approach and use a helper column B ="SN00"&A1, or better still with "SN00" in say C1 =$C$1&A1 Rgds On Wed, 23 Nov 2005 02:22:02 -0800, "GeneWan" wrote: Hi Roger, Thanks for the suggestion, I should have been more detailed: I'm trying to achieve creating the prefix so that it will appear along with the number that I key in. Eg. after typing "12" the cell should show SN0012, where "SN00" is my prefix. Appreciated.. :) "Roger Govier" wrote: Hi Gene A bit sparse on requirements but here's a guess With part number in A1 ="Part Number 0"&A1 Regards Roger Govier GeneWan wrote: Richard Buttrey __ |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to create a prefix containing text and zero?
I used the custom format of "SN00" but the zero will not show...
"Bob Phillips" wrote: How about a custom format of "SN00"0 -- HTH RP (remove nothere from the email address if mailing direct) "GeneWan" wrote in message ... I see.. I was trying to avoid creating an additional column, I was not sure if I could achieve it, but if you suggest otherwise, Roger's approach would be the most straightforward.. it's a shame, coz I could get the "SN" to appear, but I lost the zero that I need. Thanks! "Richard Buttrey" wrote: Without a macro you can't. Why not adopt Roger's approach and use a helper column B ="SN00"&A1, or better still with "SN00" in say C1 =$C$1&A1 Rgds On Wed, 23 Nov 2005 02:22:02 -0800, "GeneWan" wrote: Hi Roger, Thanks for the suggestion, I should have been more detailed: I'm trying to achieve creating the prefix so that it will appear along with the number that I key in. Eg. after typing "12" the cell should show SN0012, where "SN00" is my prefix. Appreciated.. :) "Roger Govier" wrote: Hi Gene A bit sparse on requirements but here's a guess With part number in A1 ="Part Number 0"&A1 Regards Roger Govier GeneWan wrote: Richard Buttrey __ |
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to create a prefix containing text and zero?
The format is SN00"0 including the quotes and the final 0.
-- HTH RP (remove nothere from the email address if mailing direct) "GeneWan" wrote in message ... I used the custom format of "SN00" but the zero will not show... "Bob Phillips" wrote: How about a custom format of "SN00"0 -- HTH RP (remove nothere from the email address if mailing direct) "GeneWan" wrote in message ... I see.. I was trying to avoid creating an additional column, I was not sure if I could achieve it, but if you suggest otherwise, Roger's approach would be the most straightforward.. it's a shame, coz I could get the "SN" to appear, but I lost the zero that I need. Thanks! "Richard Buttrey" wrote: Without a macro you can't. Why not adopt Roger's approach and use a helper column B ="SN00"&A1, or better still with "SN00" in say C1 =$C$1&A1 Rgds On Wed, 23 Nov 2005 02:22:02 -0800, "GeneWan" wrote: Hi Roger, Thanks for the suggestion, I should have been more detailed: I'm trying to achieve creating the prefix so that it will appear along with the number that I key in. Eg. after typing "12" the cell should show SN0012, where "SN00" is my prefix. Appreciated.. :) "Roger Govier" wrote: Hi Gene A bit sparse on requirements but here's a guess With part number in A1 ="Part Number 0"&A1 Regards Roger Govier GeneWan wrote: Richard Buttrey __ |
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to create a prefix containing text and zero?
Try using a custom number format. In Excel 2002 you would get to this by way of Format Cells Number Custom In the Type box (it likely says General as a default), type "SN00"0;;; This will cause "SN00" to precede the number that you type type in. For example, 12 will display as SN0012. Negative numbers, zero, and text entries will display as blank. -- rsenn ------------------------------------------------------------------------ rsenn's Profile: http://www.excelforum.com/member.php...o&userid=29050 View this thread: http://www.excelforum.com/showthread...hreadid=487549 |
#10
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to create a prefix containing text and zero?
Thanks Bob! exactly what I was looking for~
"Bob Phillips" wrote: The format is SN00"0 including the quotes and the final 0. -- HTH RP (remove nothere from the email address if mailing direct) "GeneWan" wrote in message ... I used the custom format of "SN00" but the zero will not show... "Bob Phillips" wrote: How about a custom format of "SN00"0 -- HTH RP (remove nothere from the email address if mailing direct) "GeneWan" wrote in message ... I see.. I was trying to avoid creating an additional column, I was not sure if I could achieve it, but if you suggest otherwise, Roger's approach would be the most straightforward.. it's a shame, coz I could get the "SN" to appear, but I lost the zero that I need. Thanks! "Richard Buttrey" wrote: Without a macro you can't. Why not adopt Roger's approach and use a helper column B ="SN00"&A1, or better still with "SN00" in say C1 =$C$1&A1 Rgds On Wed, 23 Nov 2005 02:22:02 -0800, "GeneWan" wrote: Hi Roger, Thanks for the suggestion, I should have been more detailed: I'm trying to achieve creating the prefix so that it will appear along with the number that I key in. Eg. after typing "12" the cell should show SN0012, where "SN00" is my prefix. Appreciated.. :) "Roger Govier" wrote: Hi Gene A bit sparse on requirements but here's a guess With part number in A1 ="Part Number 0"&A1 Regards Roger Govier GeneWan wrote: Richard Buttrey __ |
#11
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to create a prefix containing text and zero?
Thanks! Got it working now!
"rsenn" wrote: Try using a custom number format. In Excel 2002 you would get to this by way of Format Cells Number Custom In the Type box (it likely says General as a default), type "SN00"0;;; This will cause "SN00" to precede the number that you type type in. For example, 12 will display as SN0012. Negative numbers, zero, and text entries will display as blank. -- rsenn ------------------------------------------------------------------------ rsenn's Profile: http://www.excelforum.com/member.php...o&userid=29050 View this thread: http://www.excelforum.com/showthread...hreadid=487549 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|