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
– JasonAizkalns, Commented Apr 27, 2015 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
– tea_pea, Commented Apr 27, 2015 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
– Paul, Commented Apr 27, 2015 at 14:58

Community · Accepted Answer · 2017-05-23 11:51:05Z

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, 2017 at 11:51

CommunityBot

11 silver badge

answered Apr 27, 2015 at 14:18

Fjodr

1,02314 silver badges32 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

chancea · Accepted Answer · 2015-04-27 14:27:50Z

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, 2015 at 14:27

chancea

5,9683 gold badges31 silver badges40 bronze badges

Collectives™ on Stack Overflow

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

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related