Format number excel

I want to change format as below.

image

to format ##,### and don’t show decimal but if click in cell formula= show decimal

image

Now I use assign currentRor(“FYP”) = string.Format(“{0:n0}”, Cdbl(CurrentRow(“FPP”)))

From formula , It round decimal but don’t show decimal in tab formula.

Please guide me for solve it.

Or any solution for solve it ?

Hi!

Try this:

You could replace “.00” with “” (empty string).

Ex:-

Var=Var.Replace(“.*”,“”).ToString

Regards,
NaNi

HI @fairymemay

You want the value not to be round off and you want like 12,498.5 something like this ?

Regards
Gokul

@Gokul001 @THIRU_NANI My input as below.

image

In column FPP show 4456 but in real number 4455.65 (see in formula)

But I Want output as below.

image

Have , and don’t show decimal in cell excel —> But if i click this cell in formula show decimal original.

Please guide me for solve it.

You want to use this value some where after getting it or you need to change directly in Excel ?

Regards
Gokul

Hi @fairymemay

If yes , Here is the workflow and Input Excel

Sam.xlsx (9.1 KB)

Sequence1.xaml (16.7 KB)

Regards
Gokul

1 Like

@Gokul001 I think it not correct.

My input and output that correct.
Sam.xlsx (10.2 KB)

image
image

Hi @fairymemay

I would suggest formula based approach here

Do this approach

  1. Read the excel file and store in dt1
  2. use write cell activity (excel application scope), to write two formulas in A2, A3

write cell at A2 -----> “=TEXT(A2,”+Chr(34)+“##,###”+Chr(34)+“)”
write cell at A3 -----> “=TEXT(A3”+Chr(34)+“##,###”+Chr(34)+“)”

  1. We will use autofill range to fill these complete to all other cells under A column
    parameters: source range: “A2:A3”
    destination range : “A2:A”+(dt1.Rows.Count+1).ToString

This will autofill to other cells if needed.

Try this approach

I hope this would work

Thanks & Regards,
Nived N

1 Like

Int index = Array.FindIndex(InputDt.columns.cast(of datacolumn).select(function (x) x.columnname.tostring().Tolower()).toarray(),“fyp”)