decimal point

Hi, ABCDE1± 0.00001explaination : ± Custom (in this case ± 0.00005)explaination : 21.22122Valid Numbers : 1.22121 , 1.22122 , 1.22123Valid Numbers : 1.22117 , 1.22118 , 1.22119 , 1.22120 , 1.22121 , 1.22122 , 1.22123 , 1.22124 , 1.22125 , 1.22126 , 1.2212731.22127RESET. New Valid Numbers ...

Hi, thanks for reading! Using Excel 2007 and cant share file right now but it's easy to explain: Basically, I have a formula calculating the difference between 2 cells which are custom formatted to display seconds in this way: hh:mm:ss.000 and calculations are done with these numbers which...

Afternoon all, I have just imported a CSV into Excel 2010 which contains fictional sale data from my friend's online game. The value of the sales has been recorded as a long continuous string of numbers but should read as Gold, Silver and Copper coin currency, for example 10g20s44c. For...

Hi, I have a sheet full of numbers, but I need to change their format to my native (that is Czech) where we use a decimal comma instead of a decimal point. Otherwise, my Excel won't add up or substract the data. If I perfom the following code manually, it works. Selection.NumberFormat =...

Hello I am working on a sheet which I will have to send off to the payroll department for the pay of sick aid it is essential that the amount calculated shows the result with two decimals without rounding it!... i.e.: the result is 69.6666666666..... => when I set the cell to only show two...

Hi Guys. I am a student and certainly not an expert in Excel. It would be greatly appreciated if someone could help me with this issue. What I would actually like to do is from a column of data be able to pick out those that have more than 2 decimal places, or 3 decimal places. I would like...