starts with decimal point only if number is like 0.###...
 

Hi All,

Do you know what should be the number formatting if I want to achieve this:

..151843 instead of 0.151843 (=beginning zero falls out)
but
1.182 stays the same (=if the number begins with something else than 0. than
we keep it as it is)

Thanks for your help on this!
Rgds,
Mark

starts with decimal point only if number is like 0.###...
 

Hi,

Maybe a custom format of

..00

Mike

"markx" wrote:

Hi All,

Do you know what should be the number formatting if I want to achieve this:

..151843 instead of 0.151843 (=beginning zero falls out)
but
1.182 stays the same (=if the number begins with something else than 0. than
we keep it as it is)

Thanks for your help on this!
Rgds,
Mark

starts with decimal point only if number is like 0.###...
 

or even

..#######

Mike

"markx" wrote:

Hi All,

Do you know what should be the number formatting if I want to achieve this:

..151843 instead of 0.151843 (=beginning zero falls out)
but
1.182 stays the same (=if the number begins with something else than 0. than
we keep it as it is)

Thanks for your help on this!
Rgds,
Mark

starts with decimal point only if number is like 0.###...
 

[=1]General;[<=0]General;.##########


"markx" wrote:

Hi All,

Do you know what should be the number formatting if I want to achieve this:

..151843 instead of 0.151843 (=beginning zero falls out)
but
1.182 stays the same (=if the number begins with something else than 0. than
we keep it as it is)

Thanks for your help on this!
Rgds,
Mark