formula

[ramaeng]

Can anyone tell what is the formula for add 1+090 plus 2+090 (please)

 

[Mike H]

Hi,

Surprisingly it's

=1+90
=2+90
or to add the lot

=1+90+2+90

Mike

 

[Gord Dibben]

090 is not a number so you cannot add anything to it.

If 090 is actually 90 with a custom format of 000 then

=1+90+2+90 would be 183


Gord Dibben MS Excel MVP