convert now() to general

lezawang

Well-known Member
Joined
Mar 27, 2016
Messages
1,565
Hi
I typed =now() and I got 4/25/19 8:31, then I changed cell format to general and I got 43580.3552
My question, how can I get 4/25/19 8:31 back (day and time) from that number 43580.3552 ? (suppose undo is not working)
 

Some videos you may like

Excel Facts

How can you automate Excel?
Press Alt+F11 from Windows Excel to open the Visual Basic for Applications (VBA) editor.

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
40,719
Office Version
365
Platform
Windows
Format the cell as date & time
 

Joe4

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
53,412
Office Version
365
Platform
Windows
They are really the same value.
It is important to understand how dates and times work in Excel. Dates are just whole numbers, specifically the number of days since 1/0/1900, and time is just the fractional component of one day.
To easily see this, enter any day/time, and change the format to "General".
So a Date/Time is just a number with a Custom Format.

So all you need to get your date/time back is just change the format to a date/time number format.
 

Watch MrExcel Video

Forum statistics

Threads
1,099,142
Messages
5,466,923
Members
406,510
Latest member
wizekor

This Week's Hot Topics

Top