G Guest Apr 10, 2007 #1 i would like to seperate figures in lakhs and not in millions eg 1,00,000 & not 100,000 how do i do it
i would like to seperate figures in lakhs and not in millions eg 1,00,000 & not 100,000 how do i do it
B Bob Phillips Apr 10, 2007 #2 use a custom format of [>=10000000]##\,##\,##\,##0.00;[>=100000]##\,##\,##0.00;##,##0.00 will format say 1234567890 as 123,45,67,890.00 -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy)
use a custom format of [>=10000000]##\,##\,##\,##0.00;[>=100000]##\,##\,##0.00;##,##0.00 will format say 1234567890 as 123,45,67,890.00 -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy)
