lacs to million

[hk7279]

how to show value in lacs to value in million in Excel 2007

[icestationzbra]

give an example. a sample spreadsheet with before / after scenario may be best.

how are your values stored? do they have commas in them already? or, are they stored as pure numbers?

for those not in the know, a 'lac' (or lakh) is 'one-hundred-thousand'.

[hk7279]

current shows like : 1,00,00,000.00

I need to have : 10,000,000.00

[icestationzbra]

if this value - 1,00,00,000.00 - is in A1, put this formula in B1:

Please Login or Register  to view this content.