Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Could someone tell me if this is possible and how to do it if it is in using
the custom number formats in Excel. I want to have thousands separators in my number. I know how to add this but my problem is that if there is no decimal part of the number then I dont want the decimal point to appear. If there is a decimal part then I want the decimal point involved. It would be even better if I could have it do 2 digits of precision if there is a decimal part but that is not totally necessary. For Example 8300 8300.25 8300.20 754 Thanks, Mark |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Convert [h]:mm sum total format to number format | Excel Worksheet Functions | |||
Number format exactly the same, displays differently in some cells | Excel Discussion (Misc queries) | |||
Number format for Combobox | Excel Discussion (Misc queries) | |||
16 digit number wont keep alteration unless format cell to text | Excel Discussion (Misc queries) | |||
How do i change numbers in text format to number format? | New Users to Excel |