LinkBack URL
About LinkBacks
novice2430 
I need help with a custom number format.
The numbers in the worksheet read like this: 114'31.5
The number behind the hyphen are not to exceed 32, after 32 they become a full point (115'00.0). Thanks for the help in advance!
I need help with a custom number format.
The numbers in the worksheet read like this: 114'31.5
The number behind the hyphen are not to exceed 32, after 32 they become a full point (115'00.0). Thanks for the help in advance!
Last edited by mudraker; 06-24-2008 at 10:07 PM. Reason: Change thread title
novice2430
Welcome to Exceltip forum
Please take a couple of minutes and read the Forum Rules then edit your thread title by following the instructions in the rules (Rule 1)
Please Read Forum Rules Before Posting
Wrap VBA code by selecting the code and clicking the # icon or Read This
How To Cross Post politely
Top Excel links for beginners to Experts
If you are pleased with a member's answer then use the Scales icon to rate it
If my reply has assistedor failed to assist you
I welcome your Feedback.
Anyone have an answer?
I don't understand what you are trying to do. Do you want the user to enter a value that is then converted into this format? Or do you want to change a list of decimal numbers to this format? Or change from this format to binary? Or what?
Sorry for not being clear.
I want the user to be able to enter a value and then it's converted into this format. I also need the number in front of the ' to round up 1 when the number behind the ' goes over 32.
You can't do it with formatting, but you can use a formula that displays a number entered in another cell in that fashion:
=INT(A1) & "'" & TEXT( ROUND( (A1 - INT(A1)) * 64, 0) / 2, "00.0")
For example,
--A--- ---B---- 1 953.78 953'25.0 2 651.28 651'09.0 3 123.59 123'19.0 4 347.24 347'07.5 5 6.71 6'22.5
Last edited by shg; 06-29-2008 at 01:45 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks