View Single Post
 
Old 03-20-2018, 04:06 AM
schewi schewi is offline Windows 8 Office 2010 64bit
Novice
 
Join Date: Mar 2018
Posts: 3
schewi is on a distinguished road
Default date and numbers in excel

Dear colleagues,

I know the topic is very simple and has been discussed and solved many times, but I did not have a quick solution, and I think you can solve the problem in seconds :-), if I put data from a special software (sensor) in an Excel column, Excel writes instead of numbers months as in the appendix, I have even tried everything with cells formatting, nothing helped. can I do that with a rule or formula? if yes how?

Mai.86
15.Jun
Mär.84
18.86
Feb.35
Mär.54
Mär.21
Okt.52
Jun.59
11.Jän
Mär.38

br
Schewi
Reply With Quote