Excel Coding

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

cypher2

Thread Starter
Account Closed
Joined
Dec 1, 2004
Messages
119
Hi,

Anyone out there any good at Excel coding?

I need to be able to enter a number, and excel calculate this by Oct (on the Scientific calculator ) and then reverse this figure?

any help

thanks
 
Joined
Sep 4, 2003
Messages
4,916
I can code Excel pretty well. Post what need in a little more detail and I'll try to help if I can. Here is the basic code

Code:
Public Sub ConvertToOct()

vNumber = 10

vOct = Oct$(vNumber)

MsgBox (vOct)

End Sub
Rollin
 

cypher2

Thread Starter
Account Closed
Joined
Dec 1, 2004
Messages
119
Thanks for getting back to me

Although we have done it now

nice one!
 

cypher2

Thread Starter
Account Closed
Joined
Dec 1, 2004
Messages
119
OK - bare with me cos i dont know jack about excel::

OK - we need to take a basic 4 digit number from one column and in the next colum have this number dec2oct which i believe is =DEC2OCT(ref to cell)

then in the next column i need for this OCTAL'd number to be reversed

any good? ? ?
 
Joined
Sep 4, 2003
Messages
4,916
cypher said:
which i believe is =DEC2OCT(ref to cell)
This sounds like a custom function because there is no built in function in Excel to do this. Also, what do you mean reversed? You want to convert the OCT value back to its original value?

Rollin
 
Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 807,865 other people just like you!

Latest posts

Members online

Top