Greek Characters Dont Display Properly

Apr 9, 2008

I cant seem to get an excel file that I have received from a Greek collegue to display Greek Characters properly.

Some of the lines in the file with Greek appear to be correct and have not been turned into gibberish.

In addition the cell properties of both the correctly displayed cell and the gibberish cell are exactly the same and in the cell format sample the gibberish is displayed as Greek Characters.

Ive tried formatting the corrupted cells with the uncorrupted cells format but that doesnt seem to have any effect.

View 3 Replies


ADVERTISEMENT

A Few Macros Dont Work Properly With Personal.xls

Jun 18, 2008

I wondered if I could pick your brains and hopefully get some answers to my problem. I have recently been using the Personal.xls worksheet to make all my Macros available to all open workbooks so that I don't have to cut and paste Macros each time I wanted to use them.

Now I know you sometimes have to make certain adjustments to Macros in order to make them work globally. I wondered if I could find out how to amend the codes below to make them work properly. Thanks.

The first code Macro below deletes all worksheets in a workbook except for the currently active sheet. However it no longer works.

View 14 Replies View Related

Dont Display #N/A

Jul 30, 2009

Basically I have a =VLOOKUP(E2,Sheet3!$A$1:$C$7442,2,FALSE) And sometimes it doesnt find the number its looking up, so theres no data to display, so it just shows #N/A is there anyway I can make the =VLOOKUP(E2,Sheet3!$A$1:$C$7442,2,FALSE) display "not found" if it doesnt find anything?

also sometimes if it does find the number its looking up, and the cell next to it is blank, it just displays 0. I could filter it.. and then just replace all the 0 and #N/A with not found, but im just wondering if i could do it in the code too.

View 5 Replies View Related

Date Does Not Display Properly?

May 6, 2013

I have formatted cells to date but when I enter in a date of 020413 (Feb 04, 2013) my reslut shows as 11/20/55. I have a coworker who is having the same problem (but hers displays even a different date) so was wondering if there is a setting in excel that I don't know about.

View 1 Replies View Related

Check All The Spelling, Spaces, But Not Display Properly

Apr 11, 2008

=IF(D$21="SOUTH FLORIDA 6","6 MONTH FENCE RENTAL",
IF(AND(D$21="SOUTH FLORIDA 12",S15=24),"24 MONTH FENCE RENTAL",
IF(AND(D$21="SOUTH FLORIDA 12",S17=12),"12 MONTH FENCE RENEWAL",
IF(AND(D$21="SOUTH FLORIDA 6",S16=6),"6 MONTH FENCE RENEWAL",
IF(AND(D$21="SOUTH FLORIDA 12",S14=18),"18 MONTH FENCE RENTAL",
IF(D$21="SOUTH FLORIDA 12","12 MONTH FENCE RENTAL",
"BIKE BARRICADES ARE ALSO AVAILABLE"))))))

I having trouble getting this IF statement to function properly. The Bold section is the part that will not function properly. I have checked all the spelling, spaces, but for some reason it wont display properly.

Based on the above is there a way to make this a type of lookup?

Im at wits end with all the ifs.

View 9 Replies View Related

Command Button To Display Calendar Doesn't Function Properly

Mar 17, 2014

Userform1 on the attached file has a "Calendar" button to display a calendar that allows the user to select a date and have it placed in the Date Text Box. It simply doesn't work unless you click on the userform area where the calendar should appear - but how would the user know that?

View 2 Replies View Related

Sorting The Greek Alphabet

May 1, 2008

I need to sort a series of fraternity chapters. I have a list of the chapters that has been alphabetically sorted but this is a problem.

When sorted alphabetically, the list will show as:

Alpha
Alpha Alpha
Alpha Beta
Alpha Gamma
Etc…

When it needs to be sorted:

Alpha
Beta
Gamma
-
Omega
(and then)
Alpha Alpha
Alpha Beta
Alpha Gamma
Etc…

View 9 Replies View Related

Insert Greek Delta Symbol Into Header Using VBA

Sep 24, 2012

I'm trying to figure out how to insert the delta symbol into a header using VBA. The symbol code is 0394. My line of code is the following but it is giving me a weird "D"-like symbol. Any thoughts on how to correct this?

Code:

ActiveWorkbook.Sheets("The Flux").Range("G2") = ChrW(394) & " Prev. Year"

View 2 Replies View Related

Display All Characters In Cell

Jul 2, 2008

I have entered text as I would like in the formula bar. However not all of the text is displayed in the cell. I have sized the cell so it should definitely dispaly all text. Word wrap is on But the text displayed in the cell is truncated

Also the spreadsheet was originally in 2007 format, I converted to 2003. I also tried copying all text from the formula bar, pasted to notepad, deleted from Excel, copied from Notepad, pasted back to the formula bar. Still not all text is displayed. In a helper cell I dropped in =len(xx) where xx is the reference. Returned 1357

View 3 Replies View Related

Cell Will Not Display All Text Characters? !

Aug 14, 2008

I pasted in 1369 characters (including spaces) to a cell, and NO MATTER what I try, all characters will not print.

If I have the cell up for formatting on the function line, all text can be seen, but for some reason it cuts off the last sentance or more and will not show it in print preview.

I've tried all kinds of cell text formatting, cell merging, etc. with no luck. The only work around I found is to just have the "missing text" on the following row.

View 4 Replies View Related

Split The Characters And Display Other Cells

Nov 4, 2009

I want to accept a string, well typically a name say "Manik" from one of the cells in Excel say "B2"; then split it as characters M a n i k and display it in five other cells like say from D2:D6. how can I do it? Also the name may change its not a fixed string.

View 9 Replies View Related

Remove Unknown Characters & Display As Multi-Line Wrap Text

Mar 27, 2008

I have a exel file which has been exported from Access to exel. There are many cells which shows the data as in Cell A1 with the Linefeed character in between data in a cell. Is there any way (may be using a macro) where I can remove the character and get it to display as B1 in the same cell(A1). The file is attached herewith.

View 5 Replies View Related

Dont Return A Zero Or N/A

Jul 12, 2007

I have a VLOOKUP formula and if it looks and does not find a match it will either put a "0" or a N/A. Is there something I can add to it to leave the cell blank if it does not find a match?

View 9 Replies View Related

VBA Dont Run For Dutch?

Apr 27, 2006

I've developed a VBA application for excel in my english version. Now I sent to the client, wich is dutch and use dutch office. they say it gives errors at simple lines like TextBox1.Left=100. It seems there is no Left property. I installed their office but Left is there for me. I suspect their configuration have some version of VBA with translated code language... like using Links instead Left... wich is same thing for dutch. What could cause VBA translation of properties so I can have same configuration as they do?

View 4 Replies View Related

Look Up Dont Repeat Row Of Data

Jul 24, 2009

I have rows of data that repeats every now and again and codes next to them What I need to do is have same row of data (without it repeating) and relevant codes next to these across the page. Tried doing Pivot table and failed. Example and proposed format enclosed.

View 4 Replies View Related

Dont Recalculate Links

Dec 29, 2009

I am using Excel 2007. I have read that if you open an excel 2003 document, that has external links, the links will be recacluated automatically. How do I change the settings in '07 so that the links are not recalculated when I open a 2003 excel file?

View 9 Replies View Related

Dont Sum Hidden Columns

Apr 16, 2008

I have a spreadsheet with rows as budget line item and columns for the months they occur.

I have a cell on each row (in column B) displaying the total of that row for all the months. (columns C to Z)

I want to be able to hide certain months (columns), and have the total not include those hidden columns; but the formula for the totaling cell ( "subtotal(109,C3:Z3)" ) appears to continue counting all the columsn, even the hidden ones

View 5 Replies View Related

Concatenate And Dont Change The Formating

Mar 23, 2009

I am making a spreadsheet and would like the "placement" tab to look at the "years in position" column and go to another tab and find the corresponding data then put that information into the cell that the formula is in. I have concatenated and the value carries out to about 6 decimal and I cant change the formating. I would like it to display as a currency with 2 decimal places.

If you look at the placement tab cell H7 you can see what I am trying to do. If you change the value in d7 to a value that is on tab 06-09 step plan (b9-b23) then the value is put in other wise noting is returned.

View 2 Replies View Related

Lookup Formula: Dont Count

Nov 9, 2009

=SUMIF('[Weekly Sheets.xlsx]W1'!$A$8:$A$10000,$C$1,'[Weekly Sheets.xlsx]W1'!$K$8:$K$10000). It works fine but I need it to also lookup cell B8 if B8 has text named "ABS" dont count whats in cell K8

View 2 Replies View Related

Dont Find The Empty Cell In Vba

Oct 27, 2008

The first one works fine but the "Description" and "Customer" paste over the top of each other and dont find the empty cell. im sure im missing something!

This submits the following details into the "Stored" table. It also finds an empty cell.

View 5 Replies View Related

Macros Dont Work Even On Low Security

Aug 21, 2009

My dad wrote me a VB programme to save me time entering repetitive data into an excel template for my business. At first it didnt work untilll i reduced security to low. Sice then I fried my computer and have had to reformat it with a diffirent version of windows, vista service pack 3. Now even on low security it doesnt work.

The little button in the worksheet to make the macro happen isnt visible or doesnt exist.

View 13 Replies View Related

Dont Show The Negatived Values

Jul 1, 2008

I have spread sheet that adds meter readings. As you enter the reading it subtracts from previous month's and gives you net value. But this always shows a negative value in the following month until you enter the current reading.

Also I would like to be able to total these net values as a running total. Is there a simple way to not show the negative values and or use those when getting the running total?

View 9 Replies View Related

Data Validation Dont Allow Blanks

Mar 13, 2009

I have a data validation list, but i dont want the user to be able to make the cell blank. I have 5 items in the list and i wont to make sure they choose one. But the data validation allows them to enter blank.

View 9 Replies View Related

My Links Dont Update All The Time

Jun 6, 2006

Sub unprotectEm()
ActiveSheet. Unprotect Password:="shreked"
ActiveWorkbook.UpdateLink Name:="R:SHAREDPASSACCEXCELPASSACCCONTROL.XLS" _
, Type:=xlExcelLinks
ActiveSheet.Protect Password:="shreked"
End Sub

Private Sub Workbook_Open()
If ThisWorkbook.ReadOnly = True Then MsgBox "READ ONLY YOUVE BEEN WARNED"
End Sub

It works fine until its been opened as "read only". What I mean is I open the file and the read only msg box comes up no prob. When the file avail for editing again I open the file and its not updating the control list.

View 2 Replies View Related

Delete Rows That Dont Have Certain Text

Jun 26, 2008

I have a sheet with data only in column A. I want to remove any rows that dont contain the word MAR. All the lines with MAR in start with: CN=GR GG COF MAR ****
macro which would do this as i have over a 100 sheets. and maybe an explanation as i am totally new to this?

View 2 Replies View Related

Conditional Weekdays (Dont Count The Weekends)

May 18, 2009

I am using office 2003 and I need to create the conditional (just like in the attached image), but I need that the days -1 (day) -2(days) or -3 (days) that are in the end of each formula, I need them to be weekdays (i don't want the to count weekends.

View 3 Replies View Related

Dont Include In The Average If Cell Is Zero Or Blank

May 28, 2009

I was done but the formula works great except if the cell is zero or blank I don't want it to include that cell in the average. in this case it still counts.

=IF(SUM(H32>0,H67>0,H102>0,H137>0)=0,0,SUM(H32,H67,H102,H137)/SUM(H32>0,H67>0,H102>0,H137>0))

View 3 Replies View Related

Is Empty Script Then Dont Copy The Formula

May 1, 2009

The script works however I dont want the formulas to be entered into the cells that dont have any information in them because I am using them in a list box. To sum it up. So if sheet LA (Range A3:B98) is empty then dont copy the formula. If there is a data in this range then copy the formula. Here is the script that copies the formula's I just need to check sheet LA before it does this.

View 2 Replies View Related

Index/Lookup Formula (dont Match Put 0 Instead Of #N/A)

Nov 13, 2008

=INDEX($AS$9:$AT$33, MATCH(B4,$AS$9:$AS$33,), MATCH("PERCENTAGE",$AS$9:$AT$9,))

That's all fine but some of the items in the list will not be able to match the lookup table and in this case I want it to say 0 (zero), but instead its saying #N/A which I understand means data unavailable. Is there a way of saying if so and so doesn't match put 0 instead of #N/A?

View 4 Replies View Related

Delete Rows That Dont Match Criteria

Jun 19, 2007

I have a file which has some data I want to keep and some data I want to strip out.

The data I want to keep will always have either a date or a string “Overdue” or a string “> 1 year” in the first column, anything else I want to remove.

Example file shown below

23-Apr-0812341234123412341234
30-Apr-0812341234123412341234
19-May-0812341234123412341234
27-May-0812341234123412341234
> 1 year12341234123412341234
Overdue12341234123412341234

View 9 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved