Home |
Search |
Today's Posts |
#1
|
|||
|
|||
My numbers format as a number with two decimal places.
I am trying to format numbers as a four digit number. If I format the cell
with numbers, no decimal places, no separator, the last two numbers don't show. (Instead of 1124 I get 11) If I format it as general, it come up with two decimal places. (Instead of 1124 I get 11.24). |
#2
|
|||
|
|||
Pull-down
Tools Options Edit and clear the fixed decimal checkbox. -- Gary''s Student "Tim Poulter" wrote: I am trying to format numbers as a four digit number. If I format the cell with numbers, no decimal places, no separator, the last two numbers don't show. (Instead of 1124 I get 11) If I format it as general, it come up with two decimal places. (Instead of 1124 I get 11.24). |
#3
|
|||
|
|||
Thank you for the quick answered. It was exactly what I needed.
"Gary''s Student" wrote: Pull-down Tools Options Edit and clear the fixed decimal checkbox. -- Gary''s Student "Tim Poulter" wrote: I am trying to format numbers as a four digit number. If I format the cell with numbers, no decimal places, no separator, the last two numbers don't show. (Instead of 1124 I get 11) If I format it as general, it come up with two decimal places. (Instead of 1124 I get 11.24). |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
csv converting numbers to scientific format | Excel Discussion (Misc queries) | |||
16 digit number wont keep alteration unless format cell to text | Excel Discussion (Misc queries) | |||
Mail Merge - format of numbers | Excel Discussion (Misc queries) | |||
GET.CELL | Excel Worksheet Functions | |||
Number Format Issues-Decimal Places | Excel Worksheet Functions |