excel current date

https://exceljet.net/keyboard-shortcuts/insert-current-date

CTRL + ;

when recording a macro, this action will be interpreted as insert "11/05/2016" say - rather than "insert current date"

you need

= Date

instead

Comments

Post a Comment

Popular posts from this blog

bash enquiry

Q: bash command that'll remove all empty folders in the present directory A: find . -type d -empty -delete find finds, . specifies the present folder, -type d specifies directories (to avoid deleting empty files), -empty specifies empty, -delete instructs to delete. duh.
Read more

no sound in Papers Please

No sound at all, actually. First I installed alsa-utils, checked alsamixer master was not muted. Installed pulseaudio and pavucontrol. This gave me sound on youtube but not the game. Eventually found this tip in the hotline miami AUR comments: On x86_64 I had to install lib32-libpulse to get sound working. Without the package there was that error: ALSA lib dlmisc.c:252:(snd1_dlobj_cache_get) Cannot open shared library /usr/lib32/alsa-lib/libasound_module_pcm_pulse.so AL lib: (EE) alsa_open_playback: Could not open playback device 'default': No such device or address   https://wiki.archlinux.org/index.php/Advanced_Linux_Sound_Architecture#Unmuting_the_channels https://aur.archlinux.org/packages/hotlinemiami/
Read more

Node issues

Not sure quite what happened, but I pacman -Syu ‘d as normal and got a bunch of errors relating to npm (basically a whole list of exists in filesystem errors). Now, if I’d been sensible with the xps like I was with the latitude I would’ve done $sudo pacman -Syu --ignore npm , seen a missing ca-certificates.crt file and (hopefully) found my way to the Arch news posting that told me how to resolve. I could then have --ignore ‘d npm or whatever and figured out the real deal later. What I did do was rename /usr/lib/node_modules/npm (the source of the files I could see) to npm.bak then upgrade as normal. This has fucked me. Then I get errors any time I try to run any node or npm command saying shared library error, libcrypto.so.1.0.0 does not exist. Symlinked that to whatever libcrypto I did have, got same issue for libssl.so.1.0.0. Symlinked that , got some error about undefined ssl symbols or I dunno what. So. uninstalling and resintalling npm and node doesn’t work. downgra...
Read more