Hello,
Pretty simple problem I have, I have a custom number cell as follows:
The problem is that when the number is suppose to be a fraction (ie: 0.5) the number rounds to "1" - I tried changing the number of decimal places in the "number" field, but this causes the code for the blank zero to disappear.
Please Login or Register to view this content.
At least not on my computer. It works perfectly. Have you tryed to reboot your computer?
Pierre Leclerc
_______________________________________________________
If you like the help you got,
Click on the STAR "Add reputation" icon at the bottom.
Works fine on mine too
what is te input/calc, what is it giving you, and what is your expected outcome?
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Does not do that for me in Excel 2002.
If I enter a number like 5.25 then the displayed value is 5.2 which is correct for the format.
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
But its working fine in 2003 to 2010 versionOriginally Posted by Tony Valko
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
Sorry, I should have been clear that I'm not all that good with excel, attached is the problem I'm dealing with, I would like cell E4 to be -0.5 and not -1 while still maintaining the absence of zeros on columns E & F
I would also be really interested in having the data in the yellow cells be reflected on what is entered in column B and reflected in column C. What this sheet represents is the yellow cells is how many hours we are allowed staffing for our sales per hour.
IE: If $106 is entered in B4, then 2.5 will appear in C4 or if $320 is entered into B4, then C4 would be 4.0. It's a bit more complicated than my original problem, but if anyone knows how that would be awesome.
You guys are great!
just increase the decimal places using the ribbon...home/number/increase decimal
Oh my god, thanks FDibbins. Last time I used office was before this ribbon thing.. I was right clicking in order to format it and that option was not in that menu.
Happy to help and thanks for the feedback
I will mark this thread "solved" for you, next time please use the "thread tools" above your 1st post, and select "mark this thread as closed"
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks