Originally posted by: lxskllr
Out of curiosity, is that enough for the work that needs to be done?
Originally posted by: compman25
Maybe they can get a payday loan.
Originally posted by: venkman
you typed 1,20,000 twice.
double comma fail
Originally posted by: venkman
you typed 1,20,000 twice.
double comma fail
For eg, numbers here are represented as:
1
10
100
1,000
10,000
1,00,000
10,00,000
1,00,00,000
10,00,00,000
and so on
The seperators are after two digits, except for the last set, which is in thousands.
Custom cell format :
=REPLACE(TEXT(B2,"##"",""##"",""##"",""##"",""##"",""##"",""###"),1,6-INT((LEN(B2)>3)+(LEN(B2)-4)/2),"")
