How to create a prefix containing text and zero?
 

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:

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:

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
__

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
__

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
__

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
__

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
__

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

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
__

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