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

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

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

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