python (65.1k questions)

javascript (44.2k questions)

reactjs (22.7k questions)

java (20.8k questions)

c# (17.4k questions)

html (16.3k questions)

r (13.7k questions)

android (12.9k questions)

Questions - excel-formula

Pandas read_excel with formulas and get values

So, I had some code running that opened a series of excel files and converted to dataframes using pd.read_excel, no issues. Just today, the files are now all displaying NaN instead of values. The ex...
test-img

John Taylor

excel

pandas

excel-formula

Votes: 0

Answers: 1

Latest Answer

Well, after hours of searching, this code, for some reason that is opaque to me, enabled me to use pd.read_excel() and read the values instead of just all NaN values from cells with formulas. import x...
test-img

John Taylor

Count Values Based on Date and Reference Excel Formula or VBA

By no choice of my own, I am required to create a schedule in Excel before I upload (read copy) into the scheduling app that we use. What I need to show is the number a 'p', 's', 'f', etc. days that a...
test-img

imatworkallday

excel

vba

excel-formula

Votes: 0

Answers: 0

How to have excel automatically replace one word with another word?

I'm having trouble finding my answer for this elsewhere. I need to be able to type in a code (ex. CK) and have the cell show "Checking Account" when I press enter. Or SV for Savings Account,...
test-img

Gabby

excel

excel-formula

Votes: 0

Answers: 2

Latest Answer

=if(A1=“CK”,”Checking Account”) Replace A1 with the cell range you want CK to be replaced with Checking Account. If it’s a range input like A1:A5 or A1:E1 Easiest I could come up with as a suggestion....
test-img

SidianDMW

Add special characther in notepad++/excel

I Need to replace a string like this: 20211201153000 In date format like this 2021/12/01 15:30:00 (yyyy/MM/GG hh:mm:ss) Any solution?
test-img

Nicola T

excel

excel-formula

notepad++

Votes: 0

Answers: 3

Latest Answer

Another option, using Text function only 1] In B2, enter formula : =TEXT(A2,"0000\/00\/00\ 00\:00\:00") or, 2] Convert cell to Date format, in B3 formula become: =0+TEXT(A3,"0000\/00\/...
test-img

bosco_yip

Posts

Questions

Blogs

Jobs