Luis Diaz
asked on
VBA: Insert New column with specific format type
Hello experts,
I am launching a comparison beween the two columns
The problem is that they don't have the same format.
I would like to insert a new column related to Field2, Field2 revised in Column C in order to match exactly the format reported in Column A:
-Value should aways end with €/h
-Values should reported with a decimal separator and 2 decimal places
I attached dummy file.
Thank you very much for your help.
Book5.xlsm
I am launching a comparison beween the two columns
The problem is that they don't have the same format.
I would like to insert a new column related to Field2, Field2 revised in Column C in order to match exactly the format reported in Column A:
-Value should aways end with €/h
-Values should reported with a decimal separator and 2 decimal places
I attached dummy file.
Thank you very much for your help.
Book5.xlsm
ASKER
Thank you for your help.
The formula works perfectly just for the following value:
0.00 I have in result ,01 €/h instead of having 0,01 €/h
The formula works perfectly just for the following value:
0.00 I have in result ,01 €/h instead of having 0,01 €/h
ASKER
If I want to use the same formula to have the following result:
12 041,70 €/m based on the following value 12041.7
or 15 207,47 €/m based on the following value 15207.46667
12 041,70 €/m based on the following value 12041.7
or 15 207,47 €/m based on the following value 15207.46667
ASKER
Thank you very much and for the following:
12 041,70 €/m based on the following value 12041.7
or 15 207,47 €/m based on the following value 15207.46667
12 041,70 €/m based on the following value 12041.7
or 15 207,47 €/m based on the following value 15207.46667
€/m or €/h is now taken from first column. Correct value in first column to 12 041,70 €/m
ASKER
Thank you very much it works, however in the formula we take as a reference at the same time b column and a column. We cannot just param a formula in which I putin column A 12041.7 and have as a result 12 041,70 €/m?
Thank you very much for your help.
Thank you very much for your help.
Can you upload new sample?
ASKER
Please find attached the sample.
Output is the expected result.
Thank you very much for your help.
Book2.xlsx
Output is the expected result.
Thank you very much for your help.
Book2.xlsx
How we can decide what to add: €/m or €/h?
ASKER
For this specific case €/m as I have the previous formula which works.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
=SUBSTITUTE(TEXT(B2,"#.00"
Book5.xlsm