Apr 98 to 04,98 in german excel

Copper Contributor

i have recording of data from sensor from raspberry pi to save it as the excel format since the recorded data is 04,98 it is saved as Apr 98(i am using german excel). i tried to change to number format but it gives 5 number all together and its annoying. please suggest.

5 Replies
Which format do you want it in? Is it just supposed to display "04,98"?
you could do a custom format mm/yy if you just want it to display that. You wont be able to do calculations off of it though.
="0"&MONTH(L2)&","&(YEAR(L2)-1900)
This will display the cell as 04,98. However, it will not be able to be used in calculations.
=MONTH(L2)&"."&(YEAR(L2)-1900)
Use this to display as 4.98 , This can be used in calculations

Hi @Paresh_Chauhan ,

 

Here you go.