Solved

what excel function restricts my decimal places

Posted on 2012-04-07
3
271 Views
Last Modified: 2012-04-08
I want to show a daily pay to 2 places.  What function do I need if A1 is your monthly income?   My cell is:

="your daily pay is:" & A1/30

This does not restrict "A1/30" to 2 decimal places as I need.
0
Comment
Question by:dwcronin
3 Comments
 
LVL 46

Expert Comment

by:Martin Liss
ID: 37820352
Go to Format->Cells->Number and choose 2 decimal places.
0
 
LVL 17

Accepted Solution

by:
Anuroopsundd earned 500 total points
ID: 37820363
Change your formula as below to roundup to 2 decimal places.
="your daily pay is:" & ROUND(A1/30,2)
0
 

Author Closing Comment

by:dwcronin
ID: 37821085
MartinLiss:
Thank you for the effort but your solution doesn't work if you have a mixture of text and numbers in your cell.
0

Featured Post

Gigs: Get Your Project Delivered by an Expert

Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A little background as to how I came to I design this code: Around 5 years ago I designed an add-in that formatted Excel files to a corporate standard, applying different cell colours and font type depending on whether the cells contained inputs,…
Freeze panes is an option within all variants of Excel to enable parts of a sheet to remain stationary when the cursor is in another part of the sheet. This is a very useful feature which is overlooked or under used.
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

786 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question