How to convert 3 to 3.0

Learn Academy Feedback
1

Hi everyone,

I need to format a column from excel where whenever I encountered a whole number, it will automatically be converted to a float, for example, 2 → 2.0, and 3 → 3.0. I have tried both using Convert.ToDouble and double.parse, no luck.

Any help would be grateful.

1 Like
2

Hi @jadepu2010,

Welcome to the Community.

Please use convert.todecimal or cdbl(xxxx)

image

1 Like
3

image

This is what I have done, but the result is still 3, not 3.0.

1 Like
4

Hi @jadepu2010,

Give assign size = Oz.tostring(“0.00”)

1 Like
5

Thanks, cdbl works.

1 Like
6

and Oz.tostring(“0.00”)works too

1 Like
7

Your welcome. :smiley:

Please mark the rite answer as solution

8

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.