Greetings,
The management of sheet names works in the same way as cell addresses.
Whenever you give a cell address (like A3), a copy/paste of the cell to
the next cell to the right will transform A3 into B3. To prevent that,
you place a "$" sign in front of the column address, like: $A3. You can
a
On 2021-06-12 13:59, Johnny Rosenberg wrote:
Den lör 12 juni 2021 kl 01:05 skrev Dutton:
In cell A1 there's the number 1230
In cell A2 I want the number to appear as 12:30 (a time figure)
If you only mean ”appear”, then just format the cell as:
00”:”00
or
#0":"00
depending on w how you want t
Hello:
Using LO vers 7.1.3.2 (x64) on desktop Windows 10 Home (64-bit).
I would greatly receiving an explanation of a formula or function in
Calc that updates the data within cell $Y$4 each time the data in column
[M] changes. The formula in $Y$4 =$M18-$W$4.
[M]
Den lör 12 juni 2021 kl 01:05 skrev Dutton :
>
>
> Here's what I'd like to
> do;
>
>
> In cell A1 there's the
> number 1230
>
>
> In cell A2 I want the
> number to appear as 12:30 (a time figure)
>
If you only mean ”appear”, then just format the cell as:
00”:”00
or
#0":"00
Den lör 12 juni 2021 kl 11:06 skrev Thomas Blasejewicz :
> Good evening
> I am probably, again!, too stupid to figure this out by myself,
> so I would be grateful for a hint.
>
> I have a file with something like 25 sheets listing the patients who
> visited my clinic before
> grouped by year. In o
Good evening
I am probably, again!, too stupid to figure this out by myself,
so I would be grateful for a hint.
I have a file with something like 25 sheets listing the patients who
visited my clinic before
grouped by year. In one sheet I have all names (about 2,000).
To make my work easier I s