Forum Discussion
Exel formulas don´t work anymore
Evert1959 On the home tab you'll find a group of icons for "Numbers". If it says "Text" like in the picture when you have selected C2, it's a text.
By the way, the same could be the case for C1 and B2. You could also use a formula like =ISNUMBER(C2) to see if the cell contains a number or not. If TRUE than it's a number, if FALSE it's a text.
Evert1959 Perhaps C2 is formatted as text or you accidentally pressed "Show Formulas" on the Formula ribbon.
How can I see and change this if C2 is formatted as text?
Evert1959 On the home tab you'll find a group of icons for "Numbers". If it says "Text" like in the picture when you have selected C2, it's a text.
By the way, the same could be the case for C1 and B2. You could also use a formula like =ISNUMBER(C2) to see if the cell contains a number or not. If TRUE than it's a number, if FALSE it's a text.
- I checked and it says date. Now, there is 2 settings for formatting dates and time. One says, date which allows you to put date and time in, and the other says time which lets you do the same. and the cell shows the date and time, also. Does that make a difference in calculation to add an integer to the timke?
If in cell you have time 10:00 and add integer, you will see same 10:00 if hh:mm is applied to both cells.
To see the difference use full datetime format or elapsed time format [hh]:mm
Above in right column are exactly the same values (=left cell value + 5)
- I did review your requirement and it seems you wanted to enable the remote registry services on multiple client workstations(Domain joined) and also need to restrict the settings to a specific AD group.
- I am working on a company laptop but am only working on one work station. And when I am working in Excel. It is not shared; I work off my desktop
