TriSarahTopsWasAlreadyTaken
84285
1172
33
Sep 4, 2018 3:33 AM
TriSarahTopsWasAlreadyTaken
84285
1172
33
rndadhdman
May 12 – Charles of Durazzo executes the imprisoned Joanna I of Naples, and succeeds her as Charles III of Naples.
MattGlade
It was Wednesday, by the way. Johanna I, Queen of Naples/Provence died.
MrBinns
'
MorgulTheFriendlyDrelb
working in australia for a US organisation we got fucked up with their m/d/yy instead of our d/m/yy so I made the standard mm dd, yyyy
EmbersOfWar
Format Cells then Numbers ...never get a date in a number cell
supercoffee1025
Or you could just right click and change the format like a normal person
Teksura
December 16th, 1991
reedpro
Damn it, I have to make a new spreadsheet and copy all this data again
ThatQuietlySmirking
Bull. Fucking. Shit. Excel does not recognize dates before 1900. Pain in my ass every single day.
HandsomeJack19
'
GoAheadAndDownvoteYouFlippingFascist
Are the other engineers here also struggling to identify with these MSoft Office issues? Excrl, PowerPoint, and Word are super easy to use.
GoAheadAndDownvoteYouFlippingFascist
If you're looking for a really challenging UI; just attempt to learn a propriety MRP or ERP. PLM software never makes any damn sense.
krynny
As an Excel user, this. I have a file where the default for the workbook is a date format. I hate that file.
TapToRetry
Ctrl+z ; ctrl+1 ; reformat!
opwankenop
Keep the default format of cells as text, that should help you. But I get it, Excel can be a cruel bitch!
EnemiesWithBenefits
But we use spreadsheets mostly for numbers n stuff D: - me, an accountant
DataBeardFace
To anyone that follows this advice and leaves crap behind for actual savvy users to maintain : Fuck you and your lack of technical skill.
[deleted]
[deleted]
HerrBisch
I find trying to enter a phone number in excel more frustrating. "Silly human, let me remove that redundant zero for you."
MultiservitorB123
Create a format to keep the number structure the way you want.
ChromeBadger
put ' before the number
ButICanRebuild
=“01204 etc”
Ghengiskhan3000
Yeahhh buddy pet peeve all the way
Rangermcclure
Change the cell to "text"., zeros stay
chemicalBagel
CTRL+SHFT+1, or put ' before the entry.
BigBadBrownie
I support '
heller8790
As in Clerical Support??? IF THATS THE CASE THE REQUEST YOUR SICK LEAVE PAY CAUSE YOU SICK OF THAT PLACE. BEFORE THAT, REQUEST ALL YOUR GADGETS AND ALL YOUR WORK ASSIGNMENTS PLUS YOUR EMPLOYEES OF THE MONTH CERTIFICATE ( I know you was putting that work) GET IT LAMINATED AND FRAMES. PUT THE CERTIFICATE IN A BLANKET AND BURN THE BLANKET( keep the original) REQUEST IT AS A GREEN ECO ROCK AND SEND IT TO THE WINDCHESTER. SEND ME A FRAME FOR ALL MY SEASONAL WORKERS!
heller8790
IF YOU WOULD BE SO KIND AND GRAB THE SEASONAL WORKERS GADGETS AND UNIFORMS PLUS THEIR VEHICLES AND MULTI PASS. GRAB A SOME GIFT FOR THE WINDCHESTER. I CALCULATED AND YOU WILL NOT HAVE ENOUGH RED ENERGY TO MATCH THE GREEN( Even if the eco sends 44% to you every) so THE WOOD FROM THE FALCONS WOODS WILL NOT BE ABLE TO FURNISH ALL THE PLACE.
Atria
Mine keeps expanding to this: type in 9/4/2018 and it changes to 9/4/2018 00:00. I cant not figure out to make it stop. Ugh!
mopfmopf
https://www.extendoffice.com/documents/excel/875-excel-remove-time-from-date.html
Atria
Thank you. I tried all of these and it keep formatting new dates with the time. I think I will make a new table with this data. I think
Atria
someone did something to make it when way when I inherited the excel file. I appreciate the help!
walkingtallmachinegunman
Ok let's enter this serial number 10654701 and enter. =A5+#REF!
MalukuSeito
okay, explanation please
walkingtallmachinegunman
I make alot of spreadsheets with serial numbers and admin numbers. Aligned wrong they get recognized as an equation then I get nonsense 1/
walkingtallmachinegunman
Like listed above