Here is the solution for your problem.
Open excel sheet.
For example: write 9.03 in a1.
Go to format menu or simply press the shortcut ctrl + 1 and go to number
tab.
Choose category number-tab-decimal place 0-tab-okay-enter. Copy this format
in required column or row. your problem will be solved. Thank you.
Mukesh R. Baviskar
9403161157
----- Original Message -----
From: "Kamal Verma" <kamalve...@pnb.co.in>
To: <accessindia@accessindia.org.in>
Sent: Thursday, April 22, 2010 11:28 AM
Subject: [AI] EXCEL FORMULA
Hello everyone,
I want to round off the figure in nearest rupee. Suppose, I enter 9.03 in
A1, it should appear as 10.00 in the same cell. Further, I enter 99.10 in
B1, it should automatically be changed to 100.
Please suggest me any formula or macro in this regard. Though I am well
acquainted with excel formulae, this exercise is out of my comprehension.
Kamal Verma,
DISCLAIMER:
The Information transmitted in this email is solely for the addressee. It
is confidential and may be legally privileged. Access to this email by
anyone else is unauthorized. Any disclosure, copying, distribution or any
action taken by anyone other than by the intended recipient is prohibited
and may be unlawful. If you are not the intended recipient then kindly
delete the mail from your system. Any opinion or views expressed in this
mail may not necessarily reflect that of Punjab National Bank. The bank
considers unencrypted email as an insecure mode of communication.
To unsubscribe send a message to accessindia-requ...@accessindia.org.in
with the subject unsubscribe.
To change your subscription to digest mode or make any other changes,
please visit the list home page at
http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in
To unsubscribe send a message to accessindia-requ...@accessindia.org.in with
the subject unsubscribe.
To change your subscription to digest mode or make any other changes, please
visit the list home page at
http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in