I want to change format as below.
to format ##,### and don’t show decimal but if click in cell formula= show decimal
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
Gokul001
(Gokul Balaji)
February 23, 2022, 4:56am
4
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.
In column FPP show 4456 but in real number 4455.65 (see in formula)
But I Want output as below.
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.
Gokul001
(Gokul Balaji)
February 23, 2022, 5:11am
6
You want to use this value some where after getting it or you need to change directly in Excel ?
Regards
Gokul
Gokul001
(Gokul Balaji)
February 23, 2022, 5:15am
7
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)
Hi @fairymemay
I would suggest formula based approach here
Do this approach
Read the excel file and store in dt1
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)+“)”
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”)