Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
end a number in ZERO
How can I end a number in zero without an apostrophe or entering as text?
When I enter a number (ie: 6310.5130) the last zero doesn't show in the cell, only in the formula bar. If I enter it as a number, it adds commas. -- Teri |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
end a number in ZERO
Hi Teri,
Format the cell as Text before entering the number -- Kind regards, Niek Otten Microsoft MVP - Excel "Teri Yaki" wrote in message ... How can I end a number in zero without an apostrophe or entering as text? When I enter a number (ie: 6310.5130) the last zero doesn't show in the cell, only in the formula bar. If I enter it as a number, it adds commas. -- Teri |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
end a number in ZERO
Assuming you are saying that 6310.5130 is shown as 6310.513 and you want
the latter without entering as text. Try doing this : right click on the cell choose Format Cells select Number under Cateogry in Number's tab increase decimal to 4 uncheck Use 1000 Separator(,) click ok This will show 6310.5130 without thousand separator HTH -- Your feedback is appreciate, pls click on the Yes button below if this posting is helpful. Thank You cheers, francis "Teri Yaki" wrote: How can I end a number in zero without an apostrophe or entering as text? When I enter a number (ie: 6310.5130) the last zero doesn't show in the cell, only in the formula bar. If I enter it as a number, it adds commas. -- Teri |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
end a number in ZERO
How about using a numberformat of:
0000.0000 or 0000,0000 Depending on what your decimal character is. Teri Yaki wrote: How can I end a number in zero without an apostrophe or entering as text? When I enter a number (ie: 6310.5130) the last zero doesn't show in the cell, only in the formula bar. If I enter it as a number, it adds commas. -- Teri -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to calculate number of occurencies of a specific number number | Excel Discussion (Misc queries) | |||
countif formula to find the occurances of a number that is greater than one number but less than another | Excel Discussion (Misc queries) | |||
convert text-format number to number in excel 2000%3f | Excel Discussion (Misc queries) | |||
excel format cells/Number/Category: Number problem | Excel Discussion (Misc queries) | |||
Rounding a number to a multiple quantity that adds to a fixed total number | Excel Worksheet Functions |