integer to string

[Jamie Allison]

Hi There,

I want to convert an integer number to a string equivalent for Excel such
that

0 = A,
1 = B,
26=AA,
27=AB,
255=IV,

Anyone any ideas how to do this?

I have it working for A to Z using:

char c = (char) (column + 65);

But once it gets over Z i need to work out how to put them in double
letters.

Thanks in advance.

Jamie

[Oliver Wong]

"Jamie Allison" <ja***@jamieallison.co.ukwrote in message
news:Lq******************************@bt.com...

Hi There,

I want to convert an integer number to a string equivalent for Excel such
that

Crosspost, don't multipost:
http://www.cs.tut.fi/~jkorpela/usenet/xpost.html

I answered your question on another newsgroup.

- Oliver

[Choder Hongwel]

On Fri, 28 Jul 2006 14:19:46 GMT, "Oliver Wong" <ow***@castortech.com>
wrote:

>
"Jamie Allison" <ja***@jamieallison.co.ukwrote in message
news:Lq******************************@bt.com...

>Hi There,

I want to convert an integer number to a string equivalent for Excel such
that

Crosspost, don't multipost:
http://www.cs.tut.fi/~jkorpela/usenet/xpost.html

"It is considered highly inappropriate to broadcast your message to a
wide selection of newsgroups merely to have more people read it. Note
also that many people automatically ignore articles posted to more
than two or three groups."

Hehehe!! The first sentence almost tempts the reader to do it just
out of spite. The second sentence provides a good argument for doing
exactly what you're hoping to discourage the poster from doing here
(multi-posting rather than crossposting).

I'm not disagreeing with you here Wong, I just find netcopping funny
in general. Makes me giggle and want to piss me self.

[Oliver Wong]

"Choder Hongwel" <ch****@monkey.comwrote in message
news:8s********************************@4ax.com...

On Fri, 28 Jul 2006 14:19:46 GMT, "Oliver Wong" <ow***@castortech.com>
wrote:

>>
"Jamie Allison" <ja***@jamieallison.co.ukwrote in message
news:Lq******************************@bt.com.. .

>>Hi There,

I want to convert an integer number to a string equivalent for Excel
such
that

Crosspost, don't multipost:
http://www.cs.tut.fi/~jkorpela/usenet/xpost.html

"It is considered highly inappropriate to broadcast your message to a
wide selection of newsgroups merely to have more people read it. Note
also that many people automatically ignore articles posted to more
than two or three groups."

Hehehe!! The first sentence almost tempts the reader to do it just
out of spite. The second sentence provides a good argument for doing
exactly what you're hoping to discourage the poster from doing here
(multi-posting rather than crossposting).

I'm not disagreeing with you here Wong, I just find netcopping funny
in general. Makes me giggle and want to piss me self.

The page actually makes an appeal to the laziness of the poster:

<quote>
Crossposting is easier than sending separate postings. You don't really need
any other reason.
</quote>

IOW, why should I crosspost instead of multipost? 'Cause it takes less
effort to crosspost.

- Oliver

[Choder Hongwel]

On Fri, 28 Jul 2006 18:47:26 GMT, "Oliver Wong" <ow***@castortech.com>
wrote:

>"Choder Hongwel" <ch****@monkey.comwrote in message
news:8s********************************@4ax.com.. .

>On Fri, 28 Jul 2006 14:19:46 GMT, "Oliver Wong" <ow***@castortech.com>
wrote:

>>>
"Jamie Allison" <ja***@jamieallison.co.ukwrote in message
news:Lq******************************@bt.com. ..
Hi There,

I want to convert an integer number to a string equivalent for Excel
such
that

Crosspost, don't multipost:
http://www.cs.tut.fi/~jkorpela/usenet/xpost.html

"It is considered highly inappropriate to broadcast your message to a
wide selection of newsgroups merely to have more people read it. Note
also that many people automatically ignore articles posted to more
than two or three groups."

Hehehe!! The first sentence almost tempts the reader to do it just
out of spite. The second sentence provides a good argument for doing
exactly what you're hoping to discourage the poster from doing here
(multi-posting rather than crossposting).

I'm not disagreeing with you here Wong, I just find netcopping funny
in general. Makes me giggle and want to piss me self.

The page actually makes an appeal to the laziness of the poster:

Which in itself is an admirable strategy, but is based in the
assumption that the user not only wants to widen their audience but is
willing to make tradeoffs of effort resultng in a smaller audience.