Over 1 million tech questions and answers.

Entering Chinese Text in Excel 2013

Q: Entering Chinese Text in Excel 2013

The company I work for is in the USA and is running a US version of 64 bit MS-Windows 8.1 Professional on desktop computers. We are running MS-Office 2013. Several people exchange MS-Excel files with the factory in Taiwan. A few people are finding it cumbersome to edit or enter Chinese text into cells using a standard American keyboard.

One person is asking if would be possible to attach some type of small drawing pad and stylus to the desktop so that they can hand write the text, rather than going through any kind of gyrations with an American keyboard. Is this possible? If so, are there any recommendations for an input device and any extra software that may be needed?

Read other answers
Preferred Solution: Entering Chinese Text in Excel 2013

I recommend downloading and running Reimage. It's a computer repair tool that has been proven to identify and fix many Windows problems with a high level of success.

I've used it in the past to identify and fix everything from blue screens (BSOD's), ActiveX errors, corrupt files and processes, dll/exe/sys errors, recover lost memory, Windows update problems, defragging, malware removal etc.

You can download it direct from this link http://downloadreimage.com/download.php. (This link will automatically start a download of Reimage that you can save to your computer.)


Excel 2010. Win 7 ultimate. Excel will duplicate text as I type within the same session that I originally entered the text to the spreadsheet. However, if I close the file and then reopen it it won't automatically enter text as I type of previously entered cells. Can't seem to find option to turn it on always. Hope this is clear enough. Help appreciated.

A:Excel 2010 not entering previously entered text automatically

Quote: Originally Posted by tex50

Excel 2010. Win 7 ultimate. Excel will duplicate text as I type within the same session that I originally entered the text to the spreadsheet. However, if I close the file and then reopen it it won't automatically enter text as I type of previously entered cells. Can't seem to find option to turn it on always. Hope this is clear enough. Help appreciated.

Can you post a screenshot of what it looks like when it duplicates correctly?

Read other 3 answers

Inside .acc file is a simple text, but the mighty Excel tries to open it like some kind of database. It is asking for accounts, sources, passwords etc. and finally it cannot open it at all. It can open this file if I change extension to something else like .txt or .xls. How can I turn off this useless function of Excel 2013? The Excel of 2003 just opens it without any question.

A:Excel 2013 cannot open simple text file with .acc extension

Hi gacuxz, welcome to Windows Seven Forums.

MS changed Office file extensions from version 2007. This website might it explain it for you.

Microsoft Office file extensions list

When you have opened the file in question, by the method you mention, have you tried saving it, using the Save As option, with a file extension listed in the Save As options list.

Read other 8 answers

Hi I was wondering if anyone could help me. My friend has a Chinese version of Windows XP with SP3 and an English Office 2007 installed on her computer. All worked fine until the day after Office was installed. Now some of the Chinese characters have been replaced with squares. I tried changing the settings in the Regional and Language Options but as the Chinese characters have been replaced by vertical lines.

If someone can help me resolve this problem it would be greatly appreciated.


A:[SOLVED] Problem with Chinese text in Chinese Windows XP

Problem solved

Read other 1 answers

Is it possible to enter text in one place in a word 2007 document and have it repeat elsewhere at the end of the same document?

I have a multi table document that relates to multiple individuals. One cell of each table has a 'to do' section where I would like to replicate the inputted text at the end of the document, a sort of work sheet that I can print off (printing current view).

I've had a look about and I can find references to bookmarks, linking fields and cross referencing etc but most don't seem very clear in what to do, especially in word 2007/10.

I'm using word 2007 and saving in 2003 .doc format to allow compatability with the work pc
If any one knows the clear and simple way to achieving this, it will be greatly appreciated

Read other answers

Windows2000. Cannot type emails or enter User names or passwords on the internet. Can type email addresses though and into the description field. Not in the message field or other text boxes.

Read other answers

I tried to do a restart and the windows 10 screen said an app needs to close, it was in Chinese text, so I dont know what the app is. Lenovo support could not answer the question since i am not under warranty.  I have a screen shot but dont know if I can post an image.

Go to Solution.

A:app with chinese text cant decipher

Hi kb3 , 
Welcome to the Community Forums.
You may us the Photo /Camera Icon above the reply box to insert the screenshot ,either minimize the size or upload it from online storage like Google drive/ Skydrive to create a link for viewing.
You may also open task manager and check what application /process is running to isolate the apps. 
You can also disable other start up that you don't need. 
Making sure that there is no security check , after scanning for malwares / virus , you may set cleanboot and restart the pc further isolate it. 
Update us how it goes.

Read other 9 answers

Does anyone know of any MACRO clipboard type utilities for Windows 7?

Im looking to type in certain phrases and when i type rv1 or something it will paste a line of text I previously entered for rv1?

on MAC I use typinator but Im unbale to find anything on windows 7 like this.

Any help would be appreciated

A:Clipboard or Macro for text entering?

Well I found one just now lol

Macro Recorder, Help-Desk, ASP.NET Forum - Jitbit Software.

Real good if you repeatedly type alot for text (though Im looking for a free one!!)

Works in windows 7 x64 RC 7201

Read other 4 answers

This is a real interesting problem that involves the computer at my mom's house (not mine, but one I use on occasion). On that Dell Dimension 3100 (running Windows XP), whenever I edit the ID3 tags of an mp3 inside the folder (right click>properties>summary>advance) - like say, changing the genre or adding the album title to the ID3 tag - after I press apply and go back to the folder, when the file refreshes, Chinese (or other characters) have been injected into the title (or rarely, composer) field. If I edit it again to remove it, it goes away. This text also does show up in Winamp or WMP if I did not fix it before adding it it in. Also, it does not matter if I have Winamp open while i'm editing the ID3 tags. It does not matter which mp3s I do it to.

Spybot, Malwarebytes, Avast! and Adaware find nothing wrong with the system.

Here's some screen caps (edited so they can fit here and so they can fit here, no important information is missing):

Before picture: I will be editing the ID3 tag of the Soul Coughing song "Super Bon Bon", a song which I just downloaded mere minutes ago. The songs by Of Montreal and Kenickie are there for comparison and because they were two other recent additions to my music library on this computer. This is not exclusive this one mp3 file, if I did it with any mp3, the results would be the same
Here, I have changed the genre from "Alternative" to "Indie" and am just about to click apply. That... Read more

A:Chinese Text Appears In My Files

Read other 7 answers

I try to open this Chinese setup installation file and when the screen comes up all I see is all these ??? ???? text so I'm probably thinking that my windows don't have Traditional Chinese text installed, is there a way for me to read Traditional Chinese text?

Read other answers

When I began entering text on a birthday card I was designing for my grandson I found that, instead of the text appearing, I got a small block followed by a line. I tried changing fonts and sizes but that just made the block and line larger.

I am using Photoshop Elements 5 with Vista and have not encountered this problem before. I even uninstalled and re-installed Elements but to no effect.

Please help!

A:Photoshop Elements 5: entering text problem

I know this sounds like a silly answer,, but sometimes you gatta start with the small stuff, but did you try changing the color of your text? or maybe double clicking on the background layer in the layers box on the right and unlocking that and making it transparent?

Read other 2 answers

Hi all,

Purchased a new laptop (Acer Aspire 4820T running Windows 7 64-bit) a month ago and just having a few problems as of today:

1.) Whilst entering text (irrelevant of program) when I type at my normal speed the text lags and ends up entering text backwards/ jumbled up/ too many letters. It's fine if I type really slow...but painfully so.

2.) My right shift key doesn't turn an letters into capitals or a few symbols, it only works on a few punctuation and the numbers.

I've not spilt anything on the laptop and have tried blowing under the keys/dusting them but it's the same issue. I've restarted my laptop and have not installed anything new recently.

Appreciate any help you can give!

A:Entering text backwards\One Shift key dodgy

Certainly others here may have more helpful advice, but I'd be contacting the retailer or manufacturer. Even if there are programs running and causing the text printing to lag I think the scrambled characters and the shift key malfunction are more likely hardware defects.

If you have, or can borrow, a USB or wireless keyboard you could use it to get a 2nd opinion.

Read other 1 answers

Almost every time that I click on a text field (whether in Firefox, Chrome, or even while creating a Power Point), my cursor freezes and is unresponsive for about 30 seconds. During this time, the keyboard is responsive and I am at least able to use the Tab key to move to the next text box.

In my desperation to fix this issue I have tried a few different things:
-Registry clean-up tool
-Searched the Internet for similar problems, but did not find helpful results

I am currently utilizing Trend Micro Titanium for virus protection. Any thoughts on what the cause may be?

Thank you!

A:Cursor freezes when entering text fields

Hello AnalyticAda and welcome to the forums

Stay away from registry cleaners/optimisers, they tend to do more damage than good!

Try following these instructions to see if the problem lies with your startup programs:

How to troubleshoot a problem by performing a clean boot in Windows Vista or in Windows 7


Read other 1 answers

Hello, I was wondering if someone could take a look at my Hijackthis file to see what malware is affecting my computer. The biggest problem is that links via Google are redirected to ad sites. Thanks!Logfile of Trend Micro HijackThis v2.0.2Scan saved at 6:32:42 PM, on 3/12/2010Platform: Windows Vista (WinNT 6.00.1904)MSIE: Internet Explorer v7.00 (7.00.6000.16982)Boot mode: NormalRunning processes:C:\Windows\System32\smss.exeC:\Windows\system32\csrss.exeC:\Windows\system32\wininit.exeC:\Windows\system32\csrss.exeC:\Windows\system32\services.exeC:\Windows\system32\lsass.exeC:\Windows\system32\lsm.exeC:\Windows\system32\winlogon.exeC:\Windows\system32\svchost.exeC:\Windows\system32\svchost.exeC:\Windows\System32\svchost.exeC:\Windows\System32\svchost.exeC:\Windows\system32\svchost.exeC:\Windows\system32\AUDIODG.EXEC:\Windows\system32\SLsvc.exeC:\Windows\system32\svchost.exeC:\Windows\system32\svchost.exeC:\Windows\system32\Dwm.exeC:\Windows\Explorer.EXEC:\Windows\System32\spoolsv.exeC:\Windows\system32\svchost.exeC:\Windows\system32\taskeng.exeC:\Windows\zHotkey.exeC:\Program Files\McAfee.com\Agent\mcagent.exeC:\Windows&... Read more

A:Links Redirected; Chinese Text in Browser

Hello and welcome to Bleeping ComputerWe apologize for the delay in responding to your request for help. Here at Bleeping Computer we get overwhelmed at times, and we are trying our best to keep up. Please note that your topic was not intentionally overlooked. Our mission is to help everyone in need, but sometimes it takes just a little longer to get to every request for help. No one is ignored here.If you have since resolved the original problem you were having, we would appreciate you letting us know. If not please perform the following steps below so we can have a look at the current condition of your machine. If you have not done so, include a clear description of the problems you're having, along with any steps you may have performed so far.Upon completing the steps below another staff member will review and take the steps necessary with you to get your machine back in working order clean and free of malware.If you have already posted a DDS log, please do so again, as your situation may have changed.Use the 'Add Reply' and add the new log to this thread.Thanks and again sorry for the delay.We need to see some information about what is happening in your machine. Please perform the following scan:Download DDS by sUBs from one of the following links. Save it to your desktop.DDS.scrDDS.pifDouble click on the DDS icon, allow it to run.A small box will open, with an explaination about the tool. No input is needed, the scan is running.Notepad will open with the results.Foll... Read more

Read other 2 answers


I got an email and that email was composed in English but it appears in some Chinese type of characters in my outlook 2010. Why is it so?
It is only with this email. I cannot ask the sender to resend it.

It's an exchange server email system in our environment. I am not sure about the sender email system.

My os is updated with all patches also i am using FEP antivirus.

Read other answers

Hi Team, 
This is my first post on this portal. 
I hope, I'm in the right place to discuss about my system issue. 
My desktop is running by Windows XP operating system. A virus is keep on typing text like the combination of qpppppqpppqpqpqppppqpqp without any action from my end. 
Even this kind of action is happening on Windows XP login window. If I try to enter my username and password, it is keep on adding additional text and not allowing me to enter into the Windows.
I formatted all the partitions and installed Windows XP on one of the partitions. (C drive).
The virus is get activated after new installation of Windows XP and Windows 7 Professional.
Then I bought new Anti-Virus (Trend Micro Titanium Maximum Internet Security), scanned the entire system. After the new installation of Anti virus also no solution. 
Please help me how to remove this virus and activate the system.
Selvam K

A:Automatic text entering (like qpppqqqppppp) without my action on Windows XP

Please use a different keyboard and check.

Read other 4 answers

When I am entering text in either word processing program or emails or even this program, the curser/ insertion of the next letter frequently jumps back to random points while I am typing.  Since I am not always viewing the screen, it is difficult to see where the curser  has jumped to and I have to search it out and do a lot of extra work, like erasing the new data.  This going back-and-forth consumes a great deal of time and patience and makes it many times harder to use any program where text has to be entered for anything more that a few sentences.

A:My curser jumps backward when I am entering text anywhere in the system (even in

the first thing i would do is try another keyboard and mouse (change one at a time)

Read other 5 answers


Periodically I get random mouse clicks and keyboard entering spaces or my username (but in lower case)!! I got this thing today while I was making presentation in power point.

I had MSE installed, but I didn't find anything. I uninstalled it and installed NOD32 and nothing was found either.

I followed your instructions for posting, but in GMER, I was able only to check Services, Registry, ADS and Files (selected C only). Everything else was disabled.

Currently (and in the time of scanning) I was running OS with all startup items disabled (i unchecked everything in msconfig) and now I don't get any clicking and keystroking... None of startup items seems odd to me...

DDS (Ver_11-03-05.01) - NTFS_AMD64
Run by Bruno at 0:16:30,27 on pon 04.04.2011.
Internet Explorer: 9.0.8112.16421
Microsoft Windows 7 Ultimate 6.1.7601.1.1250.385.1033.18.3990.2431 [GMT 2:00]
AV: ESET NOD32 Antivirus 4.2 *Enabled/Updated* {77DEAFED-8149-104B-25A1-21771CA47CD1}
SP: ESET NOD32 Antivirus 4.2 *Enabled/Updated* {CCBF4E09-A773-1FC5-1F11-1A056723366C}
SP: Windows Defender *Enabled/Outdated* {D68DDC3A-831F-4fae-9E44-DA132C1ACF46}
============== Running Processes ===============
C:\Windows\system32\svchost.exe -k DcomLaunch
C:\Windows\system32\svchost.exe -k RPCSS
C:\Windows\System32\svchost.exe -k LocalServiceNetworkRestricted
C... Read more

A:Random mouse clicking and entering text - virus?

I'm nasdaq

Nothing suspicious was found on your log.

If you have any difficulties or want to check further please run this tool.

Please download ComboFix from any of the links below, and save it to your desktop. For information regarding this download, please visit this web page: A guide and tutorial on using ComboFix

Link 1
Link 2

* IMPORTANT !!! Save ComboFix.exe to your Desktop


1. Close any open browsers.

2. Close/disable all anti virus and anti malware programs so they do not interfere with the running of ComboFix.

3. Do not install any other programs until this if fixed.

How to : Disable Anti-virus and Firewall...
How To Temporarily Disable Your Anti-virus, Firewall And Anti-malware Programs

Double click on ComboFix.exe & follow the prompts.When finished, it will produce a report for you.
Please post the C:\ComboFix.txt
Do not mouse click ComboFix's window while it's running. That may cause it to stall

Note: If you have difficulty properly disabling your protective programs, refer to this link --> How To Temporarily Disable Your Anti-virus, Firewall And Anti-malware Programs

For AVG antivirus and anti-spyware security software users only.


Due to recent changes in AVG and how it interacts with CF, AVG must be uninstalled to run ComboFix. You will get a message from CF stating such.

If AVG will not uninstall, it is first recommended to uninstall it with this Ap... Read more

Read other 2 answers


I have problems inputting Chinese characters. (no problem in viewing Chinese characters though)
They show up as squares in the edit field. But once I hit enter, the chinese character will show up properly.

A bit confusing but I think the screen shot below will show the situation clearer.

Some details here
- Windows 7 Home Premium Service Pack 1.
- 64 bit operating system
- Chinese Simplified Quan Pin (version 6.0)

Appreciate if anyone can help. Thanks!!

A:Chinese Characters Not Showing properly in edit text

Check encoding settings of your browser. Is it unicode? (I'm not sure enough).

Read other 2 answers

One of the applications I use shows Chinese and Japanese text in jumplist as squares. This is happening only on one computer. I tested it on some several other (32 and 64 bit) computers and it is showing everything correctly. The computer that it is not working correctly is running 32bit version of Windows 7 Ultimate. All computers are running English version of windows 7.

What can be the reason of the strange behavior? How can I fix it?

A:Application jumplist not showing Chinese and Japanese text

As you have Windows 7 Ultimate, have you tried downloading the japanese and mandarin language packs?

Read other 2 answers

Issue: All Chinese characters I try to view in text editors are being displayed as squares.

I can view the file in a browser (Chrome) and the Chinese characters appear correctly, but in text editors they are squares.

Background: I recently installed Windows 7 Service Pack 1 along with many other updates. I had not been installing any updates (yeah I know) but I wanted to be able to edit files with Chinese characters in them, so I installed all the available updates.

After I restarted the first time, I was delighted to see that the characters which were squares before were now legible Chinese characters. However, when I restarted again, the characters were back to squares.

I checked for updates and saw a few optional updates were available. I installed them, restarted, and the characters were back to being legible. I restarted again and the characters returned to being squares.

Now there are no available updates and the characters still display as squares. This happens no matter what text editor I use, be it Notepad++, Sublime Text, or plain old Notepad. The file is encoded with UTF-8 (it's been that way during both when I could see the characters and when I couldn't). It also happens no matter what font I use.

How can I fix this issue?

A:Chinese characters display as squares in text editors

My chinese word suddenly appear as Square box

Read other 2 answers


I am trying to pull a dashboard view from a "Tracker". Given below is the formula that I used:

=COUNTIFS('KT Tracker'!$T$2:$T$138,$C$2,'Tracker'!$U$2:$U$138,"<="&TODAY()+7,'Tracker'!$L$2:$L$138,'Monthly Dashboard'!$B17,'Tracker'!$AF$2:$AF$138,'Monthly Dashboard'!$A$13,'Tracker'!$AD$2:$AD$138,"<>Cancelled")

This perfectly works fine in my laptop that has excel 2013 but when I email this to my team who have Excel 2010, they only see zeros. We have checked all options like enabling Automatic Calulcation of Formula, removing all named ranges in the sheet etc., but it is just not working.

Can you please help ? This is a bit urgent and I need to present this for a meeting tomorrow.
Appreciate your help and thanks in advance !!!

A:COUNTIFS working in Excel 2013 but not in Excel 2010

It might be something to do with "<>cancelled"

Read other 1 answers

I cannot search for data in excel 2013. This is new issue. I do notice that in the find window there is an entry for Preview* in the box next to format in the options window that I have never seen before. I get the message cannot find what you are looking for but I know it is there because I am looking at it.

This is new issue. Worked until last night when I was doing a sort and had to make all merged cells uniform in size. Now I can sort but cannot find.

Have closed and reopened excel, but it did not correct problem.

A:Solved: Excel search does not work Excel 2013

Read other 7 answers

Older text files opened in Notepad display all chinese characters, yet newly created (and saved) files display in English.  Older files were copied from my old HP computer.  Running Windows 7 on an HP Pavilion.

Read other answers


I'm having trouble extracting text from the middle of a text string using Excel.

I've been searching around and there are a few ways this can be done however most really on using a function to search for the text after a specific letter or seperator.
For example singling out the middle initial of a name:

Jeffery J. Skilling
John D Doe

In Column B the First Name will be extracted using the following formula
=LEFT(A2,SEARCH(" ",A2,1)-1)

in Column C the Middle Initial will be extracted. for middle init use this formula
MID(A2,SEARCH(" ",A2,1)+1,1)
My problem is that i can't single out anything to search by to be able to define what needs to be extracted.

Below is a list containing some of the items from my list. As you can see they differ in number of characters and have multiple dashes "-". What formula/process can i use to extract the bold numbers from each of the text strings. I have about 27000 lines to process!


Once again your help is always greatly appreciated!

A:Solved: Excel: Extract text from the middle of a text string - Difficult

"multiple dashes": agreed, but in your sample all items have the same number of multiple dashes -- 3.

If that's a given, just use Data > Text to Columns with "-" as delimiter. Then delete fields 1, 2 & 4 from the results since it seems that "section" 3 is always the bold stuff.

HTH, if not post back.

Read other 3 answers


I need to enter "zero" in all the blank cells of a large spreadsheet?
I know it is something to do with Edit/Go to special/Blanks...
but I can't quite suss it!!

Need Help...

A:Excel - Entering zero in all blank cells?

Read other 8 answers

I would like to write an Excel macro that includes pausing for data entry from the keyboard. For instance I have a spreadsheet for a simple bookkeeping project. I would like a macro that, when invoked, would do this:
Type "Current income" in the cell the cursor is on.
Move two columns to the right.
Stop for me to (1) enter a dollar amount and (2) hit the "enter" key.
Move two columns to the right.
Stop for me to (1) enter a dollar amount and (2) hit the "enter" key.
End of macro.

My thanks for any help!!

A:Excel macro for entering data

Read other 11 answers

I'm creating a spreadsheet for user entry. It has some cells formatted as %. If a user enters 50, it converts to 50%. If they enter .5, it also converts to 50%, even though they're trying to enter .5 %. Is there any way I have it convert .5 to .5% instead of 50%, but still have the cell formatted to %?

A:Solved: Excel- entering .5 and 50 both become 50% in % format

Read other 6 answers

Many times in the past when I would type plain text into cells of an Excel spreadhseet, I noticed that at point, the contents of a cell would turn into sharp signs (i.e. ####################). I did not know what triggered this, but I did notice that if I change the cell type from Text to General, the cell's text would come back to normal.

Today I had this happened again, and I was determined to find out what caused it. As it turns out, if you have a Text-formatted type cell and you type more than 255 characters in it, all the cell's contents will turn into sharp signs. In order to revert to the text you must either change the cell's format to General or truncate the text manually to a maximum of 255 characters.

The problem with formatting cells as General in a text-only spreadsheet is that you cannot use characters that make Excel think you are typing a formula; that is, you cannot use hyphens or "keywords" such as "not", etc, without prefixing them with a '. This is why I normally format all cells as Text when I know I will only type text in a certain spreadsheet.

Has anyone else noticed this, and is there a solution to have more than 255 characters in a cell without having to change its type to General? Thanks for any help.

A:Excel: Text in Text-formatted cells changes to ### after the 255th character

You might want to read this:
- in general, 1024 characters is the maximum allowable in a cell, but, as you have noticed, at 255 characters they are no longer displayed in the cell normally, but you can enter 32,767 characters in total, but after 255 characters they can only be read in the formula bar.
Also, if your cell only contains numeric data, then changing the format to General will leave you with information using scientific notation.
Alas, spreadsheets are spreadsheets and not word processors.

Read other 1 answers

Good morning / Good afternoon
As a newbie I am making the first posting on your forum and I hope it is not a silly question.

I received a hard print of an excel spreadsheet with data in 9 columns (2 date formatted and 6 number formatted) of figures from my by bank and I wish 2 use them for further calculation. As I didn't get an electronic file from the bank I scanned the data sheet on the HP Scanner into text files ( rich text, plain text etc) and attempted to import the text into Excel; but I was unsuccessful. Have I attempted the impossible or did I do something wrong ?

If it is possible to do so how should I proceed ?
With thanks, anothernub

A:How 2 import text data into Excel from scanned text file ?

Read other 12 answers

Good Morning! (from the UK)

I have created a spreadsheet which has many hardcoded target values, and where you enter an actual value manually for the correct 'Initials', 'Quarter' and 'Product' (these are the 3 set variables which are controlled by drop down lists on the worksheet to ensure data validation - the lists [or nameranges] were defined in another sheet). The 4th column is a value called Actuals, where the user would enter the actual value (as mentioned).

I'm trying to create a userform, which essentially lets you select the Initials, Quarter and Product, and then you enter the Actuals value in a text box and press a button, which automatically adds it to the correct cell in the spreadsheet.

I'm fiddling around with vba but my knowledge is pathetic, and googling the answer has left me even more confused!

Any help would be greatly appreciated

Thank you!


A:excel 2007, userform for entering data

Hi there, I think the links below will be able to offer the necessary infromation to help you some:

Let us know if you get stuck

Read other 1 answers

When I enter a 16 digit number in MS Excel, the last number changes to a zero and I am not sure why. I've tried all sorts of options, with the format number, custom and nothing seems to work. Any assistance would be appreciated.

A:Problem with entering 16 digit number in MS Excel

In MS-Excel 2003 the number precision is 15 digits. Not sure about other versions. Lookup "Calculation specifications" in Excel's help file for more information.

If you are not actually using the 16 digit number in calculations, you can have Excel treat it as a 16 character text string.

Read other 2 answers

Hi Guys, I'm hoping someone can help me figure this out because it's driving me nuts that I'm clueless on coding stuff.

To keep this simple... I am looking to grab data that the National Weather Service issues out to the public and enter it into excel refreshing automatically on a daily basis.
Longer story......

I had an idea last year and brought it up to a few people&#8230; the only one who actually made it happen was a great guy with coding knowledge (Jeff fromMichiganWxSystem)

I asked if he can put together an automatic page which shows the station data but color code the daily departures.

Amazingly it didn't take him long. So he had available all Climo stations and showed all data including precip and snow and records. It was an awesome setup. http://www.michiganwxsystem.com/wxweb.php?run=climate&station=bdr

Apparently he had big health issues, never paid his hosting, and had always been off and on. He's been off now for months and owes a lot of money to get things back up.

Is this something you guys know how to grab the data from and setup an automatic retrieval ofthe data each day when the CLI comes out??

The CLI reports can be found here but I have absolutely no idea how it's entered into individual columns like he did here. . http://nws.noaa.gov/view/validProds.php?prod=CLI

Here's how it looked.

I appreciate anyone who trys to help with this.

Read other answers

I am running Excel 2007 on Vista. I have created a spreadsheet for someone not familiar with Excel and they will be adding names to it. I would like to set up the spreadsheet so that the names will sort alphabetically as they are added. I did find an answer to this question in a previous post dated 2/12/2010 and called "A Newbie Needs Help..." I am embarrassed to say that I don't know where to enter the code listed by turbodante. I guess I need to know the exact steps for entering this code. Also, will the sheet sort correctly if columns are added? Or, would I have to go in and update the code?

A:Excel 2007 Autosort - Needs steps for entering code.

Read other 14 answers

Its easy to draw text box and type in it

Is there a way to draw a text box around text that is already present without covering it up ?

A:Word 2013 text boxes

Read through this MS website, you will need to scroll down to find using it with Word.


Also have a look at this Youtube video as well.


Read other 1 answers

So I've upgraded to Outlook 2013. One problem I've got now: after typing an email and pressing enter Outlook changes the appearance of the text. It increases the font size and changes the font. I'm sure that this is some sort of automatic replace check box issue. Any ideas?

A:Outlook 2013 - Changes text appearance

Here you go: http://office.microsoft.com/en-us/outlook-help/change-the-default-font-or-text-color-for-email-messages-HA102749383.aspx

Read other 2 answers

This morning I tried to compose an email in Outlook 2013.I entered the address and subject but when I tabbed to the body of the email nothing that I typed appeared. This is odd. What could be the cause? Everything was working fine yesterday.

A:Outlook 2013 - No Text in Email

Try deleting the associated account and recreating it. Is the Outlook client only associate with one email account or several? If several; do other accounts misbehave?

Read other 2 answers


I have a userform which reads from a text file stored on a network device, and displays the text in a textbox.

A suggestion has been made by a colleague who wants to be able to perform a search on this textbox to find certain keywords. No other suggestion has been made, and I am looking into whether this is possible?

Is there anyway this can be implemented?

Any help would be appreciated.

Kind Regards


A:Excel 2003 - VBA Search through text within a text box

Read other 6 answers

Hi, We have windows 10 and office 2013. Every time we try to work in Word, it goes wonky. Tons of text appearing when you don't type it. Looks like copy/paste of random things typed. Additionally, the curser will randomly fly to the top. Sometimes, it flies to the top, and unwanted text appears. Strings of one letter. Periodically, it starts backspacing like mad. Unable to use this program now. PowerPoint is also affected. Do not know about Excel yet. We do not use Access or the other programs, so don't know about them. Please help! Have run Kaspersky, and it can't find anything.

Our computer is approximately 3 years old - is an HP all-in-one deal. touchscreen also. However, the touchscreen keyboard does not come up when the random text is being typed.

Read other answers

This has me mystified. For some bizarre reason in many emails the first paragraph I type winds up looking like a hyperlink when opened by the recipient. When the person replies I can see the hyperlink myself. It's not a live link, of course, but it looks like one- blue and underlined. So far it has happened with emails sent to a Yahoo account, but not all the time. It does not appear to be happening with mail sent to any other accounts, but since it doesn't happen all the time it's hard to tell. Any suggestions?

Read other answers

hi guys I need your help, all of my important Data inside my PC in separate D:1TB HDD I stored in the PC. But suddenly today all of my D:1TB WORD 2013, TEXT, .JPEG Photos converted into .abc format, this extension added to all of my very important files, which I am having from last 15 years,

So I can't loos this Data at all, all files becomes like this

please help me, how to get my all of my files into original proper format,

I mean node of the files are opening, when I click on it,

I already Format & reinstall Win 7 from Scratch,
And I already reinstall MS-Office also

After doing all, still I could not get back my files, I am struggling from last 20 hours continuously,

Any help appricated,


A:All of my Word 2013, Text, .JPEG Photos converted into .ab

Remove Restore_files.txt and .abc Extension (Files Encrypted)

this is exact problem and message I am getting

Read other 3 answers


I'm using Office 2013 under a recent fresh install of Windows 7 x64. What's weird for me is that the selected text color is now grey even though the "Windows Color and Appearance" applet have the color "blue" for selected items and indeed, selected files and folders have blue shading as expected in explorer, but Word doesn't obey the color. Same issue with Excel & PowerPoint. Is there anyway to make Word picks up the blue color when selecting?

Read other answers

I am using a Toshiba 64-bit laptop, running Windows 10 Home, 8gb memory, 1Tb hard drive.

Unfortunately, I did an update to Windows 10 and lost all the readable sized text in the toolbars, menus, etc, not only in Windows but also in MS Office 2013. I really need to be able to make just the font larger than 9 pts. I don't want the apps and icons so large they jump off the screen at me. And who in their right mind would think that 9pts was an acceptable size font? It should never be less than 12. They obviously have never tried looking at a screen for 36 hours straight while trying to solve a major production problem.

Since the Appearance and Personalization option has disappeared out of Windows 10, did the Office developers have the intelligence and forethought to retain the ability to make the text in the menu and toolbars larger for those of us who don't have 20/10 vision? If so, where would I find that option?

I have spent almost two days trying to fix this problem, and YES, I view it as a definite problem that should be fixed as soon as humanly possible. You can just imagine how aggravated I am at this point.

Thank you for any help you can provide.

Read other answers

Hi all,

I have a form that contains 4 text boxes. Each of these text boxes are used to search for countries in 4 different tables and are pushed into a query to help show me the desired content. My four tables are document, name, language, and origin. And there are always two field, student ID and Countries. In these four tables students can have multiple records so a student name might show up as Canadian and French.

I am hoping that the text box searches could be independent and overwrite each other when necessary. Currently if I set one text box to search a country within my Document table, that result will hinder further searches in my name Table.

I want to be able to pull results for everything I'm asking for. Such as looking for students that has a French name but also have Canadian documents regardless of their name.

On top of this I am hoping to be able to search multiple things within a text box at once. Such as looking for students with French and Japanese names and at the same time looking for students with Chinese and Canadian documents.

I've been researching for days now and I still do not have a solution. Is this possible?

I'm a bit of a newbie with access so forgive me if anything is not clear.

A:Microsoft Access 2013: Form Text Box Query Help

I'm not sure how one runs searches 'at the same time'. The best of us can only run and process one query at a time?

I'm thinking if the 4 tables were joined to Name (show all records from Name table and) on StudentID any search on name should return all records available.

Tip: in the query (of the joined tables) the criteria for name should be
"*" & [forms.formname!StudentName] & "*"
this will allow just typing a few letters of the name to return records.

Read other 2 answers


For a 'Yes/No' data type, my MS Access 2013 does not allow me to change from the default 'check box' to the 'text box' option under lookup field properties - display control. It was originally able to but I think something has happened to it.

The problem is not table or database specific as I have tried other tables and databases. I even reinstalled MS Access to make sure it was not the application's fault. It still exists and I don't know what went wrong.
Could someone please advise?

Thanks a lot.

A:MS Access 2013 Yes/No Lookup field properties can't select Text box

lycen, welcome to the Forum.
I am not sure how you managed to change it to a text field, as you can't do it in Access 2007, only to other types of "On/Off" type fields

Read other 3 answers

hi guys I need your help, all of my important Data inside my PC in separate D:1TB HDD I stored in the PC. But suddenly today all of my D:1TB WORD 2013, TEXT, .JPEG Photos converted into .abc format, this extension added to all of my very important files, which I am having from last 15 years,

So I can't loos this Data at all, all files becomes like this

please help me, how to get my all of my files into original proper format,

I mean node of the files are opening, when I click on it,

I already Format & reinstall Win 7 from Scratch,
And I already reinstall MS-Office also

After doing all, still I could not get back my files, I am struggling from last 20 hours continuously,

Any help appricated,


A:All of my Word 2013, Text, .JPEG Photos converted into .abc format, un


this is exact problem and message I am getting

Read other 1 answers