200+ Video Lessons
50+ Hours of Video
200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)
In cell H36 has included 1,88,457.00
I wrote code like below in cell H47
="Estimate amounting to Rs."&ROUND(H36,)&"-00"" is prepared to building.
It will show = Estimate amounting to Rs.188457-00 is prepared to build the building.
My result should show like below.
Estimate amounting to Rs.1,88,457-00 [coma] is prepared to build the building.
Thank u.
Naga
Excel's TEXT function can be used here and it does the rounding for you, if the formatting style excludes decimal places (like if you were using Custom formatting on a cell). Try this formula instead:
="Estimate amounting to Rs."& TEXT(H36,"#,##0") & "-00 is prepared to building."Hope this fixes your problem.