How do I add a zero after the decimal when coding in excel

Question

I am having trouble adding a zero after the decimal when coding in excel. The number that is being output is 240 and I want it to say 240.0. I have tried the round function in excel however that is only working when I have something like 242.46 and it gaves me 242.5.

Can you be more specific? What do you mean by coding? With VBA? Can you show us what you tried with code? — JasonAizkalns, Apr 27 '15 at 14:05
If it's just in a cell on a worksheet, there is an 'increase decimal' button on the home ribbon (number section) that should do it. — tea_pea, Apr 27 '15 at 14:09
that is something I have and I want to be able to make the number be 240.0 instead of 240 — Paul, Apr 27 '15 at 14:58

score 1 · Answer 1 · edited May 23 '17 at 11:51

1

Try:

oWrkSheet.Cells(110, 17).NumberFormat = "0.0"

It can work for many other numeric formats. See this post for more informations.

edited May 23 '17 at 11:51

Community

1
1

answered Apr 27 '15 at 14:18

Fjodr

919
13
32

score 0 · Answer 2 · answered Apr 27 '15 at 14:27

0

You can use a formula:

=TEXT(A1,"0.0")

Either change A1 to the appropriate cell, or surround the cell in question with a =TEXT(...,"0.0")

answered Apr 27 '15 at 14:27

chancea

5,858
3
29
39

How do I add a zero after the decimal when coding in excel

2 Answers2