I've linked 1 excel file to another. Some fields in origin file are empty,
in linked file they show as a '0'. How do I lose the '0'?

software 發表在 痞客邦 留言(0) 人氣()

I import data from a program that has a negative sign after the numbers.
(example 100-) When I try to add the numbers, they will not add. I get

software 發表在 痞客邦 留言(0) 人氣()

Hi All,

software 發表在 痞客邦 留言(0) 人氣()

Hi all,

software 發表在 痞客邦 留言(0) 人氣()

How do I download an Excel test to be used by job applicants?

software 發表在 痞客邦 留言(0) 人氣()

I have a worksheet that has an auto filter.

software 發表在 痞客邦 留言(0) 人氣()

is there an easy way after conditional formatting to count colored cells,
e.g., say the cond-formating resulted 10 cells in col A that are red and you

software 發表在 痞客邦 留言(0) 人氣()

I have some data recorded for every day for some subjects.
And the possible recorded value on each day is: 0 or 1 or 2 or 3 or 4 or null.

software 發表在 痞客邦 留言(0) 人氣()

I have a column containing date and time, for example:

software 發表在 痞客邦 留言(0) 人氣()

I have imported a report to excel which contains alot of blank rows, almost
every other row. I want to delete the blank rows so I can use the auto filter

software 發表在 痞客邦 留言(0) 人氣()