Ask a Computer Question, Get an Answer ASAP!
Hi, welcome and thank you for your question. My name is Jess and I am glad to assist you today.
I am very sorry about your issues. Few things first:
Please let me know by replying to me here so that I can help you further.
Is this set of data from the database the only file where figure and currency is NOT working? Are you saying that you can manually create figures with the currency correctly?
Can you send me a sample Excel file with few data showing the problem? You can attach it here using the paper clip icon or the Add Files button.
Thank you. Please give me a moment.
I got the file. Can you please tell me what is wrong with the data?
Yes, I am still here
Yes. I completely understand your problem now. The main cause of the problem is that, all of your data are NOT figures. They are all TEXT information thus you cannot use arithmetic operations on them.
Definitely! That is the cause of the problem. Let me check if there is something that can be done in this case. Hold on.
Sorry, but this is not a formatting issue. We need to remove the TEXT part and see if we can convert the figures into numbers.
Please give me a moment to explore if a formula can be use to do this.
Hi, sorry for this silly question. Is 0,00 the same with 0.00? Is 2,89 the same with 2.89?
Ok. Thank you. I cannot work with the , version since my Excel always shows the decimal period. So I did a Find and Replace action replacing all commas with period. Then I used formulas to extract the NUMBERS in each cell. That is the time you can format it into currency.
I will send the completed file in a moment.
Here is the finished file:
The formula I used in cell C2 is:
The RIGHT function will compute the number of characters to the right of the digits and extract them. The VALUE function is needed to convert the extracted numbers which are TEXT into numerical figures.
I hope that helped.