$ 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.

 

[awoohaw]

I don't need photographs of your excel worksheet right now. Please paste it into a Notepad page and then send me a photograph.

I've already tried to advise you that the problem may not be with excel but your source data, or how your system is copying it.

 

[awoohaw]

and if you can:

Please make it easier for forum members to help you and use the xl2bb add-in. XL2BB - Excel Range to BBCode

 

[FXA]

I don't need photographs of your excel worksheet right now. Please paste it into a Notepad page and then send me a photograph.

I've already tried to advise you that the problem may not be with excel but your source data, or how your system is copying it.

I already narrowed it down to that space in between the 3 and the 2 at N10. All I was asking for was a way to automatically eliminate that space (and/or add a comma) when the data is copied over.

 

[FXA]

There are no formulas in these cells in these rows. (See first pic below)

The Formula from G5 is:
=C5+AK8+AK9+AK10
and it reads Column N starting on Row 10 which has no formulas

The issue is the space in between the 3 and the 2 in Column N in Row 10 because that is how it is copied using copy and paste.
(See 2nd pic below)
What I am looking for is a way to have Excel remove that space between the 3 and the 2 when it is copied over

I already narrowed it down to that space in between the 3 and the 2 at N10. All I was asking for was a way to automatically eliminate that space (and/or add a comma) when the data is copied over.

 

[FXA]

I don't need photographs of your excel worksheet right now. Please paste it into a Notepad page and then send me a photograph.

I've already tried to advise you that the problem may not be with excel but your source data, or how your system is copying it.

and I did say it was my source data from the first post in this thread...

 

[MARK858]

Can't you just do a find and replace on the column. i.e. in the Find box hit your spacebar and in the Replace box do nothing and click OK

 

[FXA]

Can't you just do a find and replace on the column. i.e. in the Find box hit your spacebar and in the Replace box do nothing and click OK

I can personally but this is for the end user who knows nothing of Excel.

 

[MARK858]

I can personally but this is for the end user who knows nothing of Excel.

Are you not doing this before you send them the sheet? even then it isn't hard to teach someone to select a column, press Ctrl + F, click the replace tab and in the Find box hit their spacebar and in the Replace box do nothing and click OK.

Or record yourself carrying out the task and get them to run the macro

 

[awoohaw]

No. The format I copy and paste from I cannot change so I am looking to have excel remove the space and/or replace the space with a comma automatically

and I did say it was my source data from the first post in this thread...

And I asked if that source data was an excel spreadsheet as well, which you did not answer. If it is, then you have a problem with your source not your workbook.

 

[FXA]

Are you not doing this before you send them the sheet? even then it isn't hard to teach someone to select a column, press Ctrl + F, click the replace tab and in the Find box hit their spacebar and in the Replace box do nothing and click OK.

Or record yourself carrying out the task and get them to run the macro

Just wanted a formula or code to have this done automatically is all. Guess I'll need to go to the other forum.