All Questions
6
questions
-1
votes
2
answers
246
views
MS excel not coping data in correct format from csv file
I am coping data from csv file
it contains tables
in that table there is column name PostedDate
when i copy that PostedDate column in excel it shows wrong formatting (ie instead of / it shows -)
...
0
votes
1
answer
178
views
Number format #.# - Excel bug?
I try to use the number format #.# to display 7 as 7, but it does display "7." (in Excel, or other MS environment)
I want 7.1 to be 7.1, and 7 to be 7, and 7.49 to be 7.5, that is #.# (see ...
2
votes
0
answers
205
views
in microsoft excel how to define a default language for columns
Hi I'm working on a dictionary and need to have English words in one column and Persian translation in another. but it takes time changing language every time I want to type the English and Persian ...
0
votes
2
answers
309
views
Format cell colours based on values in two columns
I have a spreadsheet where I document correspondence received, and I have a column "Days open" with a basic formula to work out how many days the case has been open for. We split the senders into two ...
1
vote
2
answers
779
views
Highlighting Groups of Alternating Names in Excel
I have been trying to find a good way to do this but it seems like I can not find a good Conditional Formatting formula to work with what I need. I am trying to do something along the lines of this ...
-1
votes
1
answer
183
views
How to count two different column?
I really need your help regarding the below table, I need a formula to show me how many pending/closed for each project.
Project Status Project Pending Closed
VIVA closed ...