A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Post New Thread
Threads in Forum : General Discussion Forum Tools Search this Forum Feed Icon
  Thread Reverse Sort Order / Thread Starter Last Post Replies Views
! by Joe
HI there, I get an exclamation mark everytime I copy and paste formulas. Then to remove it I click in the ! and select ignore. I need to do this many many...
June 20th, 2007 12:50 PM
by JLatham Go to last post
1 135
! in Calculations by Strata
Can anyone explain to me what the ! is used for when your calculation is puling data from another worksheet. e.g. =+"sheet1'!B3 Thanks Strata
December 14th, 2005 02:15 PM
by Jack Go to last post
4 173
! removing initials and titles from name cell ! by Rayiw
Hi, I'm sure what I'm asking must have a simple solution, but I can't work out how to achieve it so thought I'd ask the experts. I have an addess list. It...
January 28th, 2005 09:47 PM
by Dave O Go to last post
1 188
! Stolen by Sanketham ! Excel Function Dictionary by Peter Noneley
I wrote the Excel function dictionary over 10 years ago. I have given it away free for all of this time. Now someone has ripped it off and is passing it on...
May 1st, 2010 01:18 AM
by ozgrid.com Go to last post
2 256
!!! THIS TIME NEXT YEAR YOU COULD BE A MAIL ORDER MILLIONAIRE !!! by !!! THIS TIME NEXT YEAR YOU COULD BE A MAIL ORDER MILLIONAIRE !!!
!!! THIS TIME NEXT YEAR YOU COULD BE A MAIL ORDER MILLIONAIRE !!! OUR MAIL ORDER STARTS, AND YOU ARE THE FIRST Dear Friends, Many people are going to tell...
November 18th, 2006 05:00 AM
by !!! THIS TIME NEXT YEAR YOU COULD BE A MAIL ORDER Go to last post
0 140
!!! THIS TIME NEXT YEAR YOU COULD BE A MAIL ORDER MILLIONAIRE !!! by !!! THIS TIME NEXT YEAR YOU COULD BE A MAIL ORDER MILLIONAIRE !!!
!!! THIS TIME NEXT YEAR YOU COULD BE A MAIL ORDER MILLIONAIRE !!! OUR MAIL ORDER STARTS, AND YOU ARE THE FIRST Dear Friends, Many people are going to tell...
November 18th, 2006 05:00 AM
by !!! THIS TIME NEXT YEAR YOU COULD BE A MAIL ORDER Go to last post
0 154
!!!!!!PLEASE HELP ME!!!!!! I'm sure it's a simple solution... by Bonnie
!!!PLEASE HELP ME!!! I have a big excel file set up where each row represents a specific city (this file is the "main file"). Then I have a seperate excel...
January 20th, 2006 10:53 PM
by Elkar Go to last post
5 175
" " means in IF function by Sorue
I'm trying to understand what does this mark mean " " in IF function (Logical test). This has been done in many Excell worksheets but I could not find...
June 12th, 2005 08:53 AM
by Ken Russell Go to last post
2 192
"#N/A" results from SUMPRODUCT by Carpie
I have approximately 10 spreadsheets in which people from multiple locations enter in savings data each month. There are two columns of particular interest in...
August 30th, 2004 02:03 PM
by Frank Kabel Go to last post
1 167
"00098" to appear by sphilip
when i type in 00098 & ENTER or TAB the 000 disappears & only 98 appears. How do i get all of 00098 to appear. we use excel 2000. cheers
May 22nd, 2005 01:34 PM
by PC Go to last post
2 181
"10th" on Excel by Wamotoo
For the past few weeks, any time I enter the number "10", the Excel program automatically adds "th" making it "10th". This is also occuring on the Word...
October 10th, 2004 12:54 PM
by Dave Peterson Go to last post
2 194
"1235" appears as "One thousand two hundred thirty five" by H. Kan
please i want to know how i convert number to text in excel datasheet or access for example : 1235.75 one thousand two hundred thirty five and 75/100 thank...
(Multi-page thread 1 2)
December 8th, 2006 08:56 PM
by Bernard Liengme Go to last post
11 292
"30" in a cell becomes "50" by Melanie
When I type in 30 or use 30 in an equation, Excel automatically reads it as 50 and displays it as 50. The keyboard has been changed a couple of times. This...
September 9th, 2004 02:20 AM
by Dave Peterson Go to last post
5 230
">="& by Angel160
For some of the queries that I have posted, people have very kindly given me the correct formulae to use. Some of these have included & (for...
November 8th, 2004 03:44 PM
by Go to last post
2 195
"A valid number is required" by Xalam
Hi there, I have a very strange problem on one of my users. I've created a DOT file with fields. Some fields are type Number with the format #.##0. The strange...
August 6th, 2005 12:35 AM
by Dave Peterson Go to last post
1 1,075
"Allow users to edit range." Office 03 vs. 97... by RH
I am working on a project related to spreadsheet security and would like to utilize the flexibility the "Allow users to edit ranges..." feature in Office 03...
May 16th, 2005 08:30 PM
by Chip Pearson Go to last post
2 170
"Alt - I - R" problem by Doug
About two weeks ago when I was trying to insert a row I found that my "Alt - I - R" function was not working. After asking around, I found this has happened...
May 3rd, 2005 12:40 PM
by Dave Peterson Go to last post
6 186
"Anchoring" one row so that it always appear in one spot? by Bridget
I don't know what it would be called or if this can even be done, but I need one entry in a spreadsheet to always be in row 26. The way I've gotten around...
June 25th, 2004 01:46 AM
by StargateFan Go to last post
5 234
"Arranged" files scroll together by Not a Happy Camper
This is driving me crazy... I often display several files at once so that I can see different sections. Ever since I've had Excel 2003, all the "arranged"...
June 27th, 2005 03:23 PM
by Not a Happy Camper Go to last post
0 162
"Auto-return" by Jaytee
Question 1: If I'm entering rows of data, can I set it up at a certain column to return to the start of the next row? So if I have 4 columns of data, I input...
September 11th, 2005 06:00 PM
by Norman Jones Go to last post
3 178
Post New Thread


Display Options
Showing threads 1 to 20 of 139764
Sorted By Sort Order
From The
Forum Tools Search this Forum
Search this Forum :

Advanced Search

New posts New posts More than 15 replies or 150 views Hot thread with new posts
No new posts No new posts More than 15 replies or 150 views Hot thread with no new posts
Closed Thread Thread is closed  
 
Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 10:50 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
Copyright 2004-2017 OfficeFrustration.
The comments are property of their posters.