$ amount does not calculate with a space

[FXA]

My issue is when I copy and paste from my source, that source has no comma in the dollar amount when the dollar amount hits the thousands and above. Is there a way around this?

Formula:

=C5+AK8+AK9+AK10

C5 = Starting Balance

AK8 =SUM(N10:N1809)

AK9 =SUM(L10:L1809)

AK10 =SUM(M10:M1809)


Thank you in advance.

 

[MARK858]

I meant a formula to embed in the cells previously without making that extra column

You can't have a formula and data in the same cell

 

[FXA]

I meant a formula to embed in the cells previously without making that extra column then doing a copy n paste ect... but will try this VB Script.

Ok, this works! Next question for this VB macro.

How do I integrate the following so the worksheet will activate and run the code when the sheet is selected?
and, is this correct code for that function to run it every time?

Private Sub Worksheet_Activate()
'your code here
End Sub

Private Sub Worksheet_Change(ByVal Target As Range)
'your code here
End Sub

 

[MARK858]

Just put the code in in the worksheet module (I've reduced it to just the bits you need [especially removed the FormulaVersion:=xlReplaceFormula2 as it won't run if your user has an older version of Excel])

Private Sub Worksheet_Activate()
Columns("N:N").Replace What:=" ", Replacement:="", LookAt:=xlPart
End Sub

 

[FXA]

Just put the code in in the worksheet module (I've reduced it to just the bits you need [especially removed the FormulaVersion:=xlReplaceFormula2 as it won't run if your user has an older version of Excel])

Private Sub Worksheet_Activate()
Columns("N:N").Replace What:=" ", Replacement:="", LookAt:=xlPart
End Sub

Like this? Just making sure I wasn't suppose to keep anything you sent me earlier?

 

[MARK858]

No in the worksheet module

 

[MARK858]

Right click the sheet tab, click view code and paste the code in the window that appears

 

[FXA]

No in the worksheet module

Ignore this question, I am erasing it

 

[FXA]

Right click the sheet tab, click view code and paste the code in the window that appears

Ignore my latest question, just saw this

 

[MARK858]

I went to Developer > Visual Basic then tried adding there.

You could also do it there but you would need to double click your sheets name (the name inside the brackets is the one that shows on your sheet tab), or right click it and click view code

 

[FXA]

Like this? Just making sure I wasn't suppose to keep anything you sent me earlier?

Very, very, very much appreciated Mark. Thank you.