data format

  1. C

    Excel is not calculating the correct prices

    Hi, Excel is not calculating the prices correctly. Dont get if this is due to data formatting or issues with excel formulas. Any suggestion to fix please ? Example from Row 1, 1270 * 217,88 should be 276.707,60, but excel calculates 276.713,24 Overall the entire sheet has the same problem...
  2. V

    Text & General Format to Data Format all the data - code/VBA required

    Hi all, we have the following data and want to convert in "date", we have tried Code 1 =TEXT(A1,"mm\/dd\/yyyy")+0 Code 2 =TEXT(G12,"mm/dd/yyyy") but problem not solved, pls check the result after using the above code and provide the code/vba, also when we copy the data...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top