While on the cell in question, right-click. Choose Format Cells. Go to the Number tab. Select the Date formatting. Then choose from the list at the right for how you want it displayed.
![]() |
Patch reliability is unclear. Unless you have an immediate, pressing need to install a specific patch, don't do it. |
SIGN IN | Not a member? | REGISTER | PLUS MEMBERSHIP |
-
converting a (julian) number into a date format
Home » Forums » AskWoody support » Productivity software by function » MS Excel and spreadsheet help » converting a (julian) number into a date format
- This topic has 7 replies, 4 voices, and was last updated 24 years, 2 months ago.
Viewing 1 reply threadAuthorReplies-
WSkfahey
AskWoody LoungerMarch 2, 2001 at 2:47 am #1779529I know how to do Format Cells, but if you look at the way I explained the data, that will not work, especially when the year is reversed when the data is brought into Excel. If I click on that cell right now in the spreadsheet and try format dates, it thinks it’s July 11th, 1927 when it should be 2/23/01. I’ve attached the file to this posting.
-
WSkfahey
AskWoody LoungerMarch 2, 2001 at 2:47 am #1779527A user in a recent class proposed the following question to me. They have data that they are importing from another database system and it brings in the date in the following format, 10054, which she said is like a Julian format (which I’m not familiar with). 01 is the month. It’s just reversed when it’s brought in from their system. 054 is the 54th day of the year. So she said that 10 054 is really 2/23/01, the 54th day of the year.
Is there an easy way to convert that number into the correct date 2/23/01?
-
WSgwhitfield
AskWoody LoungerMarch 2, 2001 at 2:49 am #1779530Have a look at the Microsoft’s explanation of working with Julian dates
-
WSkfahey
AskWoody LoungerMarch 2, 2001 at 2:55 am #1779531Geoff,
I appreciate the link to the article. I tried doing a search there before, but for some reason it didn’t find Julian. Must have been the way I was searching….
Will that solution really work in this case? The user said that the year number has been transposed in their system. (guess theirs is not really a tru Julian format?) When they see 10 for the year, it should really be 01. Is there a easy way to transpose numbers in Excel?
-Kelley
-
WSgwhitfield
AskWoody Lounger -
WSkfahey
AskWoody Lounger
-
-
-
-
H. Legare Coleman
AskWoody Plus
-
Viewing 1 reply thread -

Plus Membership
Donations from Plus members keep this site going. You can identify the people who support AskWoody by the Plus badge on their avatars.
AskWoody Plus members not only get access to all of the contents of this site -- including Susan Bradley's frequently updated Patch Watch listing -- they also receive weekly AskWoody Plus Newsletters (formerly Windows Secrets Newsletter) and AskWoody Plus Alerts, emails when there are important breaking developments.
Get Plus!
Welcome to our unique respite from the madness.
It's easy to post questions about Windows 11, Windows 10, Win8.1, Win7, Surface, Office, or browse through our Forums. Post anonymously or register for greater privileges. Keep it civil, please: Decorous Lounge rules strictly enforced. Questions? Contact Customer Support.
Search Newsletters
Search Forums
View the Forum
Search for Topics
Recent Topics
-
Chrome Can Now Change Your Weak Passwords for You
by
Alex5723
57 minutes ago -
Microsoft: Over 394,000 Windows PCs infected by Lumma malware, affects Chrome..
by
Alex5723
2 hours, 4 minutes ago -
Signal vs Microsoft’s Recall ; By Default, Signal Doesn’t Recall
by
Alex5723
2 hours, 15 minutes ago -
Internet Archive : This is where all of The Internet is stored
by
Alex5723
2 hours, 28 minutes ago -
iPhone 7 Plus and the iPhone 8 on Vantage list
by
Alex5723
2 hours, 33 minutes ago -
Lumma malware takedown
by
EyesOnWindows
9 hours, 47 minutes ago -
“kill switches” found in Chinese made power inverters
by
Alex5723
11 hours, 21 minutes ago -
Windows 11 – InControl vs pausing Windows updates
by
Kathy Stevens
11 hours, 15 minutes ago -
Meet Gemini in Chrome
by
Alex5723
15 hours, 20 minutes ago -
DuckDuckGo’s Duck.ai added GPT-4o mini
by
Alex5723
15 hours, 29 minutes ago -
Trump signs Take It Down Act
by
Alex5723
23 hours, 28 minutes ago -
Do you have a maintenance window?
by
Susan Bradley
10 hours, 37 minutes ago -
Freshly discovered bug in OpenPGP.js undermines whole point of encrypted comms
by
Nibbled To Death By Ducks
1 hour, 40 minutes ago -
Cox Communications and Charter Communications to merge
by
not so anon
1 day, 2 hours ago -
Help with WD usb driver on Windows 11
by
Tex265
1 day, 7 hours ago -
hibernate activation
by
e_belmont
1 day, 11 hours ago -
Red Hat Enterprise Linux 10 with AI assistant
by
Alex5723
1 day, 15 hours ago -
Windows 11 Insider Preview build 26200.5603 released to DEV
by
joep517
1 day, 18 hours ago -
Windows 11 Insider Preview build 26120.4151 (24H2) released to BETA
by
joep517
1 day, 18 hours ago -
Fixing Windows 24H2 failed KB5058411 install
by
Alex5723
14 hours, 41 minutes ago -
Out of band for Windows 10
by
Susan Bradley
1 day, 23 hours ago -
Giving UniGetUi a test run.
by
RetiredGeek
2 days, 6 hours ago -
Windows 11 Insider Preview Build 26100.4188 (24H2) released to Release Preview
by
joep517
2 days, 13 hours ago -
Microsoft is now putting quantum encryption in Windows builds
by
Alex5723
9 hours, 40 minutes ago -
Auto Time Zone Adjustment
by
wadeer
2 days, 18 hours ago -
To download Win 11 Pro 23H2 ISO.
by
Eddieloh
2 days, 16 hours ago -
Manage your browsing experience with Edge
by
Mary Branscombe
15 hours, 32 minutes ago -
Fewer vulnerabilities, larger updates
by
Susan Bradley
1 day, 9 hours ago -
Hobbies — There’s free software for that!
by
Deanna McElveen
9 hours, 10 minutes ago -
Apps included with macOS
by
Will Fastie
1 day, 13 hours ago
Recent blog posts
Key Links
Want to Advertise in the free newsletter? How about a gift subscription in honor of a birthday? Send an email to sb@askwoody.com to ask how.
Mastodon profile for DefConPatch
Mastodon profile for AskWoody
Home • About • FAQ • Posts & Privacy • Forums • My Account
Register • Free Newsletter • Plus Membership • Gift Certificates • MS-DEFCON Alerts
Copyright ©2004-2025 by AskWoody Tech LLC. All Rights Reserved.