LinkBack URL
About LinkBacks
Hi,
Is it possible to convert a decimal number in excel to a base 5 number. Or is there a way to have excel treat numbers entered as base 5 instead of base 10?
Thanks,
Dave
Hi,
Is it possible to convert a decimal number in excel to a base 5 number. Or is there a way to have excel treat numbers entered as base 5 instead of base 10?
Thanks,
Dave
show an excel file without confidentional information.
You also want to count with the value?
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
How big will the numbers be (base 10)? Excel doesn't have a built in method of handling base 5 numbers. I'm thinking you'll need a few User Defined Functions.
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
The numbers would all be xx.xOriginally Posted by ChemistB
Hi,
Excel can convert Base 10 to any base using the "Base()" function.
https://www.excelfunctions.net/excel-base-function.html
Does that help?
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
@MarvinP If the OP's profile is correct he has Excel 2003 The base() function was not introduced until Excel 2013
This is a post from 2012. I don't know how Marvin drudged it up.
Oops, yes - I didn't notice!
Geoff
Did I help significantly? If you wish, click on * Add Reputation to say thanks.
If your problem has been resolved please select ?Solved? from the Thread Tools menu
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks