Number format problem

try find replace . with ,

Hi Phil1 and welcome to the forum

Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.

I would also suggest that when you post your new thread, you give more info/details than you have here, and also consider uploading a sample workbook, showing what data you are working with, a few examples of what your expected outcome would be, and how you would arrive at that (remove any confidential info if necessary).
To attach a file to your post,
click advanced (next to quick post),
scroll down until you see "manage file",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.

id just change my decimal settings in the computers regional options to .

In the file you uploaded, where are these numbers?

Select col F and click the left-align button TWICE. The values that are (now) left justified are text.

Enter 0 in a cell, copy it, select the data in col F, Paste Special, Add.

By changing away from Excel's default horizontal alignment, you lose a lot of information. Bad idea.

Ok try this...

in H, i entered this, and copied it down...

=F3*1

Your cells are linked to, I presume, the source, and are on the if you look at the cell, it has ='MT4'|BID!EURUSD in it. That is normally a link to another worksheet, Im not sure what it means in your case. The values without a decimal are numbers, but the numbers showing a decimal are actually text that looks like a number

So, is there a way to change that text into a number?

Post #11??

Originally Posted by shg

Select col F and click the left-align button TWICE. The values that are (now) left justified are text.

Enter 0 in a cell, copy it, select the data in col F, Paste Special, Add.

By changing away from Excel's default horizontal alignment, you lose a lot of information. Bad idea.

Hi, I just did what you said, still not working. I don't know if you tried it yourself and solved the problem, but if you did send me the file please. It keeps giving me the #VALUE! error when I try to make a calculation with it.

If you use either shg's suggestion or mine (mine pretty much uses a helper column, shg's does not), they both convert whatever is in that cell to a value

I don't know if you tried it yourself and solved the problem

I did, and it did.

Please Login or Register  to view this content.

Press Ctrl+Alt+F9 to recalculate the sheet.