| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Numeric formatting: decimals and no decimals
Hi,
Can anyone please tell me how to format numbers so that if there is no decimal value a whole number without decimals shows up, but if there is a decimal value then a number with 1 or 2 decimal values show up? Like this: 1 0 0.2 2.3 Thank you. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Numeric formatting: decimals and no decimals
Have you tried formating as general?
-- HTH... Jim Thomlinson "ppsa" wrote: Hi, Can anyone please tell me how to format numbers so that if there is no decimal value a whole number without decimals shows up, but if there is a decimal value then a number with 1 or 2 decimal values show up? Like this: 1 0 0.2 2.3 Thank you. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Numeric formatting: decimals and no decimals
Yeah, it almost does the trick, but I'd like to get rid of the zero to the
left of the decimal (my example below mistakenly includes the zero). "Jim Thomlinson" wrote: Have you tried formating as general? -- HTH... Jim Thomlinson "ppsa" wrote: Hi, Can anyone please tell me how to format numbers so that if there is no decimal value a whole number without decimals shows up, but if there is a decimal value then a number with 1 or 2 decimal values show up? Like this: 1 0 0.2 2.3 Thank you. |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Numeric formatting: decimals and no decimals
Try
Tools - Options - View - Uncheck Zero Values -- HTH... Jim Thomlinson "ppsa" wrote: Yeah, it almost does the trick, but I'd like to get rid of the zero to the left of the decimal (my example below mistakenly includes the zero). "Jim Thomlinson" wrote: Have you tried formating as general? -- HTH... Jim Thomlinson "ppsa" wrote: Hi, Can anyone please tell me how to format numbers so that if there is no decimal value a whole number without decimals shows up, but if there is a decimal value then a number with 1 or 2 decimal values show up? Like this: 1 0 0.2 2.3 Thank you. |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Numeric formatting: decimals and no decimals
How about conditional formatting?
"Jim Thomlinson" wrote in message ... Try Tools - Options - View - Uncheck Zero Values -- HTH... Jim Thomlinson "ppsa" wrote: Yeah, it almost does the trick, but I'd like to get rid of the zero to the left of the decimal (my example below mistakenly includes the zero). "Jim Thomlinson" wrote: Have you tried formating as general? -- HTH... Jim Thomlinson "ppsa" wrote: Hi, Can anyone please tell me how to format numbers so that if there is no decimal value a whole number without decimals shows up, but if there is a decimal value then a number with 1 or 2 decimal values show up? Like this: 1 0 0.2 2.3 Thank you. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count digits before decimals and after decimals | Excel Worksheet Functions | |||
| Omitting whole numbers when formatting decimals | Excel Worksheet Functions | |||
| Conditional formatting with decimals | Excel Programming | |||
| Formatting axis decimals | Charts and Charting in Excel | |||
| Conditional formatting : amount of decimals | Excel Discussion (Misc queries) | |||
Hybrid Mode
