LinkBack URL
About LinkBacks
Hiii..
I want custom formatting for particular scenario..
125000 to 1.25
315600 to 3.16
512526 to 5.13
In short r/off in lakhs upto 2 decimals..is this possible from custom formatting? I don't want to use any of the round functions for the same..
Hiii..
I want custom formatting for particular scenario..
125000 to 1.25
315600 to 3.16
512526 to 5.13
In short r/off in lakhs upto 2 decimals..is this possible from custom formatting? I don't want to use any of the round functions for the same..
Yeah if you format as "Accouting" that will automatically display two decimal places. And you can select the appropriate currency symbol as well.
But do you also want it to divide it by 100,000 as well, or what?
Click the [* Add Reputation] Button to thank people for help!
Post Attachment: Click [Go Advanced] under the reply box; then click [Manage Attachments] to launch the attachments dialogue.
Mark Thread Solved: Go to the top of the first post; Select [Thread Tools] dropdown; Pick the [Mark thread as Solved] option.
Yes I want it to divide by 100000 also..
Try this custom format:
##,#\.##,
Please remember that formatting does not change the underlying number, so the 512526 will still calculate as 512526 - it will just display as 5.13 instead.
Regards,
Aardigspook
I recently started a new job so am a bit busy and may not reply quickly. Sorry - it's not personal - I will reply eventually.
If your problem is solved, please go to 'Thread Tools' above your first post and 'Mark this Thread as Solved'.
If you use commas as your decimal separator (1,23 instead of 1.23) then please replace commas with semi-colons in your formulae.
You don't need to give me rep if I helped, but a thank-you is nice.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks