W3Ask

How to convert a number in time with Excel ?

When we enter a date with points, is there a possibility to convert it automatically into a date with slashes, so that it could be taken into consideration as a date ?

There is two solution, with a formula like this :

=SUBSTITUE(C2;".";"/")

Or select the celles containing the date to modify, Menu > Home > Search and select > replace . by /

Count the number of occurrence in Excel
https://w3ask.com/number-occurrence-excel/

How to count the number of occurrence of values in a column? For example we have a list of towns in the A column. Among this towns, some ...

How to convert cm to feet and inches in Excel
https://w3ask.com/convert-cm-feet-inches-excel/

It might be useful to display size, for example human heights in inches and feet in order to satisfy american internet users while they are ...

Number of humans since the beginning of time
https://w3ask.com/number-humans-time/

It is difficult to estimate accurately the number of humans who have traveled the world since the beginning of time, life expectancy evolving ...

Excel macro to insert a picture with Redime
https://w3ask.com/excel-macro-insert-picture-redime/

You want to save a macro that will allow you to insert a picture (located in a directory of your hard drive disk) in an active cell where you ...

How to add lines with a VBA code in Excel
https://w3ask.com/how-add-lines-vba-code-excel/

If you want to automatically add line in your Excel sheet, you can use a VBA code. The following example will add lines after the N column in ...

How to convert a number in time with Excel ?

Related posts: