Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,477 questions
1 answer
Highlight blank cell in excel post fixed date
Blank cell to be highlighted post certain dates. For example: Cell B3 is blank which needs to be highlighted after 10-May-24. Pls note, B3 cell will remain blank till due date and numeric data supposed to be filled before 10-May-2024
asked 2024-05-04T12:27:28.4033333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(188.79999999999998, 31%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJG%3C/text%3E%3C/svg%3E)
Jayesh Gangawane
0
Reputation points
answered 2024-05-04T16:15:18.9333333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(172.8, 53%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBS%3C/text%3E%3C/svg%3E)
Barry Schwarz
2,186
Reputation points
1 answer
Require sample data sets for better practice
Hi Team, I am requesting that you please provide the sample data sets to experience real understanding and gain quality knowledge. I am learning to be a Power BI data analyst. Please guide me to where I can download the data samples to practice and…
asked 2024-05-03T06:41:10.28+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(112.00000000000001, 84%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVP%3C/text%3E%3C/svg%3E)
VenkataRamiReddy Pulikhandam
0
Reputation points
commented 2024-05-04T07:14:20.65+00:00
VenkataRamiReddy Pulikhandam
0
Reputation points
1 answer
Can my school see my files? Please read full question
I wanted to make a word document and write things in it but since I don't have Microsoft 365, I wanted to use my school account. Can they see this file? It's on my PC and not on OneDrive or anything but I'm opening it using my school account.
Word
Word
A family of Microsoft word processing software products for creating web, email, and print documents.
666 questions
OneNote
OneNote
A family of Microsoft products that enable users to capture, organize, and reuse notes electronically.
161 questions
Microsoft Teams
Microsoft Teams
A Microsoft customizable chat-based workspace.
9,121 questions
PowerPoint
PowerPoint
A family of Microsoft presentation graphics products that offer tools for creating presentations and adding graphic effects like multimedia objects and special effects with text.
221 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,477 questions
asked 2024-05-03T16:20:48.51+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(169.60000000000002, 89%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETM%3C/text%3E%3C/svg%3E)
Tym Maciejewski
0
Reputation points
answered 2024-05-03T18:59:06.6566667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(80, 13%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESA%3C/text%3E%3C/svg%3E)
Said A
711
Reputation points
0 answers
How to integrate Auth0 login on Desktop Office apps (in an Addin)
Hello, I am currently developing an Addin for Word and it is difficult to finish it because the SSO (Auth0) is working well on the web version and my plugin works wonders however I cannot login on the Windows or Mac version of Word because of the url…
Word
Word
A family of Microsoft word processing software products for creating web, email, and print documents.
666 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,477 questions
Office Development
Office Development
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Development: The process of researching, productizing, and refining new or existing technologies.
3,508 questions
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(243.2, 43%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPC%3C/text%3E%3C/svg%3E)
2 answers
One of the answers was accepted by the question author.
Can COM use Excel as an in-process DLL?
Hello, I would to ask about Excel COM operation. To connect to Excel from another C++ process is well established: #import "C:\\Program Files (x86)\\Common Files\\microsoft shared\\OFFICE11\\MSO.DLL" #import "C:\\Program Files…
Office
Office
A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.
1,317 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,477 questions
C++
C++
A high-level, general-purpose programming language, created as an extension of the C programming language, that has object-oriented, generic, and functional features in addition to facilities for low-level memory manipulation.
3,537 questions
asked 2024-05-03T10:05:47.41+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(275.2, 51%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EM%3C/text%3E%3C/svg%3E)
masterjodi
40
Reputation points
commented 2024-05-03T11:45:41.7533333+00:00
masterjodi
40
Reputation points
2 answers
Table column reference in Excel
I am trying display column elements using "=Tracking[Type]" Tracking is table name and Type is column name. This gives value Error.
asked 2024-05-02T10:31:05.1533333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(169.60000000000002, 35%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EEK%3C/text%3E%3C/svg%3E)
Ehtisham Karim
0
Reputation points
commented 2024-05-03T10:20:54.2466667+00:00
Ehtisham Karim
0
Reputation points
1 answer
Excel VBA Error with user access Permission.Add
Hello, I wrote the following Excel Macro to assign user permission to the Excel file. Sub Add_Permission() Dim objUserPerm As Office.UserPermission Set objUserPerm = ActiveWorkbook.Permission.Add("test@test.com", msoPermissionChange) …
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,477 questions
Windows 365 Business
Windows 365 Business
A Microsoft cloud operating system.
413 questions
Office Development
Office Development
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Development: The process of researching, productizing, and refining new or existing technologies.
3,508 questions
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(35.2, 86%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ED%3C/text%3E%3C/svg%3E)
0 answers
excel data streamer
Im facing a problem regarding data streamer in excel i my laptop when i add in data stream extension it show like that my laptop specification is Edition Windows 11 Home Single Language Version 22H2 Installed on 17-Mar-23 OS…
asked 2024-05-03T04:52:30.6233333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(192, 90%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ES0%3C/text%3E%3C/svg%3E)
secondary 04 phone
0
Reputation points
asked 2024-05-03T04:52:30.6233333+00:00
secondary 04 phone
0
Reputation points
0 answers
VSTO Excel Com Add-in using Visual Studio 2022 and Office 64 bit vs 32 bit installer
I have a VSTO Excel Com Add-In that uses a webviewer. 64 Bit installer Excel 2021 64 Bit, Shows in menu bar and shows the webviewer control when installed. Excel 365 64 Bit, Shows in menu bar BUT does not show the webviewer control when…
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,477 questions
Office Development
Office Development
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Development: The process of researching, productizing, and refining new or existing technologies.
3,508 questions
asked 2024-05-02T21:04:17.66+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(265.6, 67%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPL%3C/text%3E%3C/svg%3E)
Potter, Lizbeth
0
Reputation points
edited the question 2024-05-03T01:33:24.53+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(249.60000000000002, 10%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAX%3C/text%3E%3C/svg%3E)
Anna Xiu-MSFT
25,801
Reputation points Microsoft Vendor
0 answers
Excel script for filling cells within a specified range with a specific fill color if any cell within the range is selected
Using scripts in Excel (NOT VB macros), I need to be able to fill any cell within a specified range with a specific color if any cell within the range is selected ("clicked on"). Note that the spreadsheet will have different columns that need…
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,477 questions
VB
VB
An object-oriented programming language developed by Microsoft that is implemented on the .NET Framework. Previously known as Visual Basic .NET.
2,579 questions
Office Development
Office Development
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Development: The process of researching, productizing, and refining new or existing technologies.
3,508 questions
Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,645 questions
asked 2024-03-31T14:28:49.82+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(227.2, 26%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERT%3C/text%3E%3C/svg%3E)
Robin Theodore
0
Reputation points
edited the question 2024-05-02T17:06:50.7833333+00:00
Robin Theodore
0
Reputation points
1 answer
Problema para printar um Formulario do VBA
Ola, quando eu executo o codigo UserForm1.Printform no meu formulário do vba, ele gera um PDF com um PrintScreen do formulário porem o formulário fica pela metade, alguem consegue me ajudar?
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,477 questions
Office Development
Office Development
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Development: The process of researching, productizing, and refining new or existing technologies.
3,508 questions
asked 2024-04-11T19:26:06.9233333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(198.4, 95%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJC%3C/text%3E%3C/svg%3E)
Julio Cezar Francisco Martin
0
Reputation points
edited the question 2024-05-02T08:56:38.49+00:00
Jack J Jun
24,296
Reputation points Microsoft Vendor
1 answer
One of the answers was accepted by the question author.
How to find course with certificate in Excel
Hey I am using this fantastic site a lot these days to improve my skills and get certificates on it for my LinkedIn profile. I need some certificates on Excel, but cant find a course directed to it. Does anyone have an advice on that? Best regards, Sune
Office
Office
A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.
1,317 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,477 questions
asked 2024-04-26T09:02:44.6666667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(44.800000000000004, 60%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ES0%3C/text%3E%3C/svg%3E)
SuneRoedJeppesen-0182
20
Reputation points
accepted 2024-05-02T07:55:15.35+00:00
SuneRoedJeppesen-0182
20
Reputation points
1 answer
One of the answers was accepted by the question author.
Full list needed
Hi, I want to get the full list of Cell E31. Please help. https://1drv.ms/x/s!Ai8CrEskdewXzm8D7avpzkgjfPqA?e=8Texgx
Office
Office
A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.
1,317 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,477 questions
asked 2024-04-25T07:01:30.0033333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(236.8, 43%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EP%3C/text%3E%3C/svg%3E)
Peter_1985
2,526
Reputation points
accepted 2024-05-02T07:29:17.5533333+00:00
Peter_1985
2,526
Reputation points
2 answers
*How would I write the formula to automatically pull the name of the items from the box of information without getting blanks or duplicates?
Hello, I'm trying to create a list of Names and the Number of times they appear from a box of information similar to the picture. Current data range is B2:AT21 Below the data range I was in putting the Formula How would I write the formula to…
asked 2024-04-28T17:30:54.58+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(220.8, 61%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJ%3C/text%3E%3C/svg%3E)
JayDee
0
Reputation points
commented 2024-05-02T02:10:48.62+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(147.20000000000002, 13%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJH%3C/text%3E%3C/svg%3E)
Jiajing Hua-MFST
5,070
Reputation points Microsoft Vendor
1 answer
Comparing dates in Excel
Hi, I have three columns in my Excel sheet: customer_id, entry_date and leave_date. I want to check whether the same patient has rentered within 14 days after leaving last time. In other words, i want excel to check in a separate column if, for a given…
asked 2024-05-01T19:57:25.39+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(70.4, 8%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EM%3C/text%3E%3C/svg%3E)
michal2002
0
Reputation points
answered 2024-05-01T21:25:05.0933333+00:00
Barry Schwarz
2,186
Reputation points
1 answer
One of the answers was accepted by the question author.
How to pull a value based on two conditions from table
How do I create a formula where two data points in Sheet1 are compared to a table in Sheet2 to output the intersecting data. Thank you very much for any help :)
Office
Office
A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.
1,317 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,477 questions
asked 2024-04-29T21:31:25.32+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(268.8, 31%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDL%3C/text%3E%3C/svg%3E)
dane linhoff
20
Reputation points
commented 2024-04-30T19:28:05.66+00:00
dane linhoff
20
Reputation points
0 answers
Urgent Help Needed: Why have embedded Excel, PowerPoint, and Word iframes in third-party applications suddenly stopped working and are stuck on the login page?
Hello, I am writing to report a critical issue we are currently facing with Microsoft Office iFrames. Until recently, we have successfully integrated Excel, PowerPoint, and Word iFrames within our applications. However, these iframes are now consistently…
asked 2024-04-26T10:38:09.1+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(176, 76%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMB%3C/text%3E%3C/svg%3E)
Mohamed Berrada
10
Reputation points
commented 2024-04-30T18:03:25.09+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(310.4, 36%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJD%3C/text%3E%3C/svg%3E)
John Dodd
0
Reputation points
1 answer
One of the answers was accepted by the question author.
IF/COUNTIFS formulas not working correctly
Hello. I was able to get help from this community several years ago in developing the formulas in the attached. Unfortunately, something is not allowing (at least some of) the formulas in cells L4:L15 to work correctly now. I know for a fact that the…
asked 2024-04-26T19:18:23.99+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(172.8, 1%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJE%3C/text%3E%3C/svg%3E)
Joel Ekstrom
20
Reputation points
accepted 2024-04-30T17:45:32.5733333+00:00
Joel Ekstrom
20
Reputation points
1 answer
Multiple work profiles in Edge. Opening a SharePoint-online word/excel file in work Profile B and this the file open in Word/Excel with Profile A
We work with users that have multiple accounts, in one M365 tenant, each user has seperated these accounts with its own Profile in Edge, eg Profiles A, B, C, D, etc. This is because we have a shared environment for multiple companies (4 in total),…
Microsoft Edge
Microsoft Edge
A Microsoft cross-platform web browser that provides privacy, learning, and accessibility tools.
2,144 questions
Word
Word
A family of Microsoft word processing software products for creating web, email, and print documents.
666 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,477 questions
SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
9,682 questions
asked 2024-02-07T12:33:02.2233333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(60.8, 45%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJK%3C/text%3E%3C/svg%3E)
Jimmy K
1
Reputation point
commented 2024-04-30T15:22:37.4933333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(188.79999999999998, 9%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDL%3C/text%3E%3C/svg%3E)
Damien Laugier
0
Reputation points
3 answers
One of the answers was accepted by the question author.
How to fix numbers (eg: 12.06; 30.11; 28.05; etc...) into numbers
Numbers that are in the format 12.06; 11.03; 30.12; etc... gets turned into dates, but when I try correct it instead of showing 12.06 it shows 45455. I´m unsure why the values change to such high numbers. How can I fix this issue?
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(22.400000000000002, 60%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EO%3C/text%3E%3C/svg%3E)