what excel function restricts my decimal places

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.
dwcroninAsked:
Who is Participating?
 
AnuroopsunddConnect With a Mentor Commented:
Change your formula as below to roundup to 2 decimal places.
="your daily pay is:" & ROUND(A1/30,2)
0
 
Martin LissOlder than dirtCommented:
Go to Format->Cells->Number and choose 2 decimal places.
0
 
dwcroninAuthor Commented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.