| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Number format still uses decimal point | New Users to Excel | |||
| Show decimal point only if not a whole number | Excel Discussion (Misc queries) | |||
| Converting 2-place decimal value to floating point decimal number with leading zero | Excel Discussion (Misc queries) | |||
| position of decimal point when entering a number ... | Excel Discussion (Misc queries) | |||
| How do I round last number without a decimal point | Excel Worksheet Functions | |||
Linear Mode
