I have a report for sending to the bank that I need a total of 10 spaces filled either with values or leading 0s.
I need the 2 number characters after the decimal point to stay intact but without the decimal. We then copy to notepad to send to the bank. Also I am having trouble concatinating the whole string because it removes some of my custom formatting but that's another issue.
Example:
From This-
00001188.75
To This-
0000118875
Date
Votes
4 comments
-
Jet Reports Historic Posts Official comment Why don't you just multiply the number by 100.
For example, =NL("Rows","G/L Entry","=100*NF(,""Amount"")")
or
=NL("Sum","G/L Entry","Amount")*100 -
Jet Reports Historic Posts Hi,
Excel =REPLACE(Old_text, Start_num, Num_chars, New_text) function should work.
e.g. C4 = 00001188.75
D4 = =REPLACE(C4;9;1;"") -
Jet Reports Historic Posts Hi bArt,
Thanks for the quick response but I'm afraid I didn't give enough information.
The record that I am pulling is from the Navision "G/L Entry" Table from the "Amount" Field.
When I bring it into Excel with JetReports I format it with 0;00000000.00 in order to maintain the numbers after the decimal and to remove the minus sign.
So when I tried your solution it reverted to the original format which changes the position of the decimal and adds the minus sign back in.
Thanks again,
RCBloomberg -
Jet Reports Historic Posts Well that was too easy, Thanks Chuck
Please sign in to leave a comment.