[Convert Number from Excel]

That's what I was afraid of. Thank you for your help Step.

[Convert Number from Excel]

Sorry Step. I think I copied an old number. The only number that will truly need to be a "1" is the last digit. I am just trying to keep from having to touch the Excel spreadsheet at all and have FusionPro do all of the work. I cannot get the output I want in Excel by converting it "text" without also going through the extra step of formatting the cell to "custom" and changing the type to "01".

 

Here is another example: 4.72E+16 needs to convert to 472001055674610001

[Convert Number from Excel]

Thanks Step. That works, but I need it to add the 1 at the end. Will I be able to modify this code so that the number will display as 472000000000000001?

[Convert Number from Excel]

Should this be posted on a different board?

[Convert Number from Excel]

I have a number in a data column in excel displaying 4.72E+16, but I need it to read 47200000000001001. Currently I am achieving this in Excel by formatting the cells to a Number with 0 decimal places and entering 01 for the type in Custom. Is there a JavaScript in FusionPro to achieve this same result?

[Editing Number Currency Rule]

Thanks. I am starting to learn some of the fundamentals of JavaScript again. I was able to replace all of that junk script with just that one line.

[Editing Number Currency Rule]

This is an example of what I currently have:

 

var Var1 = "CALCULATION";

var Format = "Format1";

var CurrencySymbol = "Symbol1";

var amount = Field("CALCULATION");

var result = "$0.00";

if (amount != "0") result = "$" + FormatNumber("#,###.00", amount);

return result;

symbol = "";

symbol2 = "";

if (CurrencySymbol == "Symbol1")

{

symbol = "$";

symbol2 = "USD";

}

if (CurrencySymbol == "Symbol2")

{

symbol = "?";

symbol2 = "EUR";

}

if (CurrencySymbol == "Symbol3")

{

symbol = "£";

symbol2 = "GBP";

}

if (CurrencySymbol == "Symbol4")

{

symbol = "¥";

symbol2 = "YEN";

}

 

function SwitchDelimiter(x)

{

x = ReplaceSubstring(x, ".", "a");

x = ReplaceSubstring(x, ",", ".");

x = ReplaceSubstring(x, "a", ",");

return x;

}

 

if (Format == "Format1")

return symbol + FormatNumber("#,###.##", Field(Var1));

 

if (Format == "Format2")

return symbol + SwitchDelimiter(FormatNumber("#,###.##", Field(Var1)));

 

if (Format == "Format3")

return symbol + FormatNumber("####.##", Field(Var1));

 

if (Format == "Format4")

return symbol + SwitchDelimiter(FormatNumber("####.##", Field(Var1)));

 

if (Format == "Format5")

return symbol2 + "" + symbol + FormatNumber("#,###.##", Field(Var1));

 

if (Format == "Format6")

return symbol2 + "" + symbol + SwitchDelimiter(FormatNumber("#,###.##", Field(Var1)));

 

if (Format == "Format7")

return symbol2 + "" + symbol + FormatNumber("####.##", Field(Var1));

 

if (Format == "Format8")

return symbol2 + "" + symbol + SwitchDelimiter(FormatNumber("####.##", Field(Var1)));

 

if (Format == "Format9")

return symbol + FormatNumber("#,###.##", Field(Var1)) + "" + symbol2;

 

if (Format == "Format10")

return symbol + SwitchDelimiter(FormatNumber("#,###.##", Field(Var1))) + "" + symbol2;

 

if (Format == "Format11")

return symbol + FormatNumber("####.##", Field(Var1)) + "" + symbol2;

 

if (Format == "Format12")

return symbol + SwitchDelimiter(FormatNumber("####.##", Field(Var1))) + "" + symbol2;

[Editing Number Currency Rule]

Thanks Step. Changing it to 00 worked. This may be a stupid question, but is there any way to import the rules that I created for this job into another job?

[Editing Number Currency Rule]

Also, would there be any way to set up the script to add .00 after the number if comes in without the 2 decimal places as well?

[Editing Number Currency Rule]

Thanks Eric that worked perfectly.

 

Step,

 

When I tried adding your argument in the Number to Currency Javascript it returned everything as $0.00.

[Editing Number Currency Rule]

Newbie here. Thanks for any help.

 

I currently have 10 fields within a database that I will need to convert to currency once imported. Is there anyway to modify the "Number to Currency" rule so that when the number = "0", "$0.00" is returned without affecting any of the numbers that do not = "0"?