Roman numbers and Alfabetical numbers

[nesplb]

Hi again mates!

Does anyone know if there is a function that can convert integers to roman numbers (1= |, 2= ||, 3= |||, 4= |V etc.) and a function that can convert integers to alfabetical numbers? (1= a, 2 = b etc.) in VBA?

In advance thanks!

Pål, Oslo , Norway

Pål Nesteby

PDC-Tangen
Norway

 

[nesplb]

I guess there is no function, but its possible to write one. If anyone is interesseted please let me know. I found a nice function on the net.

Pål, Oslo, Norway

Pål Nesteby

PDC-Tangen
Norway

 

[SkipVought]

Hi,

"integers to alfabetical numbers" is easy.

Check out the ASCII value of Numeric Characters and Alphabetic Characters.

Skip,
[sub]
When a group touring the Crest Toothpaste factory got caught in a large cooler, headlines read...
Tooth Company Freeze a Crowd! and
Many are Cold, but Few are Frozen![/sub]

 

[combo]

According the first question, see ROMAN excel function and Application.WorksheetFunction.Roman for excel vba.
Concerning second part, use Char function with proper argument shift.


combo

 

[nesplb]

Yeah
Thanks people!

Pål Nesteby

PDC-Tangen
Norway