Hi
How do I add up (B2:B7) if the amount comes with a S$ in front of the numbers. Right now I re-key the amount next to the cell C2 to do so.
Can anyone help
Cheer
<table border="1" cellpadding="0" cellspacing="0"><tbody><tr style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt; FONT-WEIGHT: bold"> <td>
</td> <td>A</td> <td>B</td></tr> <tr style="HEIGHT: 23px"> <td style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">1</td> <td style="TEXT-ALIGN: center">Code</td> <td style="TEXT-ALIGN: center; FONT-FAMILY: Arial Narrow">Amount</td></tr> <tr style="HEIGHT: 23px"> <td style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">2</td> <td style="TEXT-ALIGN: center">A</td> <td style="FONT-FAMILY: Arial Narrow">S$204.78</td></tr> <tr style="HEIGHT: 23px"> <td style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">3</td> <td style="TEXT-ALIGN: center">B</td> <td style="FONT-FAMILY: Arial Narrow">S$2.00</td></tr> <tr style="HEIGHT: 23px"> <td style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">4</td> <td style="TEXT-ALIGN: center">C</td> <td style="FONT-FAMILY: Arial Narrow">S$77.50</td></tr> <tr style="HEIGHT: 23px"> <td style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">5</td> <td style="TEXT-ALIGN: center">D</td> <td style="FONT-FAMILY: Arial Narrow">S$52.15</td></tr> <tr style="HEIGHT: 23px"> <td style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">6</td> <td style="TEXT-ALIGN: center">E</td> <td style="FONT-FAMILY: Arial Narrow">S$200.00</td></tr> <tr style="HEIGHT: 23px"> <td style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">7</td> <td style="TEXT-ALIGN: center">F</td> <td style="FONT-FAMILY: Arial Narrow">S$48.20</td></tr> <tr style="HEIGHT: 23px"> <td style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">8</td> <td style="TEXT-ALIGN: center">Total</td> <td>
</td></tr></tbody></table>
How do I add up (B2:B7) if the amount comes with a S$ in front of the numbers. Right now I re-key the amount next to the cell C2 to do so.
Can anyone help
Cheer
<table border="1" cellpadding="0" cellspacing="0"><tbody><tr style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt; FONT-WEIGHT: bold"> <td>
</td> <td>A</td> <td>B</td></tr> <tr style="HEIGHT: 23px"> <td style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">1</td> <td style="TEXT-ALIGN: center">Code</td> <td style="TEXT-ALIGN: center; FONT-FAMILY: Arial Narrow">Amount</td></tr> <tr style="HEIGHT: 23px"> <td style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">2</td> <td style="TEXT-ALIGN: center">A</td> <td style="FONT-FAMILY: Arial Narrow">S$204.78</td></tr> <tr style="HEIGHT: 23px"> <td style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">3</td> <td style="TEXT-ALIGN: center">B</td> <td style="FONT-FAMILY: Arial Narrow">S$2.00</td></tr> <tr style="HEIGHT: 23px"> <td style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">4</td> <td style="TEXT-ALIGN: center">C</td> <td style="FONT-FAMILY: Arial Narrow">S$77.50</td></tr> <tr style="HEIGHT: 23px"> <td style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">5</td> <td style="TEXT-ALIGN: center">D</td> <td style="FONT-FAMILY: Arial Narrow">S$52.15</td></tr> <tr style="HEIGHT: 23px"> <td style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">6</td> <td style="TEXT-ALIGN: center">E</td> <td style="FONT-FAMILY: Arial Narrow">S$200.00</td></tr> <tr style="HEIGHT: 23px"> <td style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">7</td> <td style="TEXT-ALIGN: center">F</td> <td style="FONT-FAMILY: Arial Narrow">S$48.20</td></tr> <tr style="HEIGHT: 23px"> <td style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">8</td> <td style="TEXT-ALIGN: center">Total</td> <td>
</td></tr></tbody></table>