Home

Cannot use date fomat in table column for Excel pre-loaded Blood Pressure tracker worksheet

%3CLINGO-SUB%20id%3D%22lingo-sub-809653%22%20slang%3D%22en-US%22%3ECannot%20use%20date%20fomat%20in%20table%20column%20for%20Excel%20pre-loaded%20Blood%20Pressure%20tracker%20worksheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-809653%22%20slang%3D%22en-US%22%3E%3CP%3EIn%20Office%20365%2C%20MS%20has%20an%20Excel%20worksheet%20called%20%22Blood%20Pressure%20Tracker.%22%26nbsp%3B%20For%20a%20while%2C%20dates%20would%20format%20correctly%20in%20US%20date%20format%2C%20but%20now%20they%20want%20to%20use%20the%20%2F%20marks%20and%20divide%20the%20numbers.%26nbsp%3B%20I've%20had%20to%20use%20an%20%3D%20sign%20in%20the%20formula%20bar%20and%20enter%20the%20dates%20as%20text.%26nbsp%3B%20Any%20clues%3F%26nbsp%3B%20I%20can%20send%20the%20table%20to%20someone%20if%20needed.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-809653%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Richard_H2460
Occasional Visitor

In Office 365, MS has an Excel worksheet called "Blood Pressure Tracker."  For a while, dates would format correctly in US date format, but now they want to use the / marks and divide the numbers.  I've had to use an = sign in the formula bar and enter the dates as text.  Any clues?  I can send the table to someone if needed.

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
38 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies