Welcome to OStack Knowledge Sharing Community for programmer and developer-Open, Learning and Share
Welcome To Ask or Share your Answers For Others

Categories

0 votes
209 views
in Technique[技术] by (71.8m points)

How to format cell in Excel for displaying of PHP version?

I'm failing on saving of PHP versions in Excel. PHP versions are numbers like 7.0.2 - all of my tries to format cells for displaying such numbers are failed.

After inserting i see dates, if format cell as text, than dates turn into 5 digits numbers.

I've tried to create a custom format like #.#.#, but this gets only a point into 5 digits numbers.

Example: from 4.6.20 i get 04.06.2020. If turn to text - it becomes 43986. If format this as #.#.#, it turns into 43.896.

How can i display properly PHP version in Excel?


与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
Welcome To Ask or Share your Answers For Others

1 Answer

0 votes
by (71.8m points)
等待大神答复

与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
Welcome to OStack Knowledge Sharing Community for programmer and developer-Open, Learning and Share
Click Here to Ask a Question

...