How to create a prefix containing text and zero?

R

Roger Govier

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:
 
G

GeneWan

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.. :)
 
R

Richard Buttrey

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

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.. :)
Click to expand...

Richard Buttrey
__
 
G

GeneWan

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!
 
B

Bob Phillips

How about a custom format of "SN00"0

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
B

Bob Phillips

The format is SN00"0 including the quotes and the final 0.

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
R

rsenn

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.
 
G

GeneWan

Thanks Bob! exactly what I was looking for~

Bob Phillips said:
The format is SN00"0 including the quotes and the final 0.

--

HTH

RP
(remove nothere from the email address if mailing direct)
Click to expand...
 
Top