CA Day celebration 2024 Easy Office
LCI Learning

HOW TO GET FIGURES IN LACS AT THE CALLED CELL IN EXCEL

This query is : Resolved 

26 January 2008 HI to all!!

Kindly make me aware whether there is any command by which i can automatically convert the figures in LACS /THOUSANDs
e.g suppose in a particular sheet containig profit and loss account the figures of sales is 1925892.00 now in the comparative sheet if i m calling the figures from p&l, i want the called figure would automatically rounded of to in lacs i.e. as 19.26

26 January 2008 You can set macro command for your auto conversion of Rupees in lakhs. Kindly refer the help menu in Excel for creating macros.





You need to be the querist or approved CAclub expert to take part in this query .
Click here to login now

CAclubindia's WhatsApp Groups Link


Similar Resolved Queries


loading


Unanswered Queries




Answer Query