 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / August 2006strange one
when ever i copy certain information inta a cell the cell formats to some arabic language. the data i copy in is A4-1500. when i copy in A4-500 or A4-1000 it works fine only this specific number. also it doesnt mater how the cell is format before copying it always over rides and if i format after it turns from arabic to a string of numbers not to the A4-1500 i copied in help please >when ever i copy certain information inta a cell the cell formats to some >arabic language. the data i copy in is A4-1500. [quoted text clipped - 6 lines] > >help please That is, indeed, a very strange one. For some reason, when you type in A4-1500 (as well as some other strings), Excel is both interpreting the value as a date and formatting it into Arabic! I can't believe this is deliberate. One work around is to either pre-format the cell as TEXT, or precede the entry with a single quote. The single quote will not show up in the cell, although you will see it in the formula bar. It tells Excel to treat the entry as text. --ron Thanks ron but i am copying in bulk and have to return to that one cell every time i am currently using the apostrophie to make it text. i have tried it on a colleagues computer and it does not auto format so there must be a way to turn it off > >when ever i copy certain information inta a cell the cell formats to some > >arabic language. the data i copy in is A4-1500. [quoted text clipped - 18 lines] > you will see it in the formula bar. It tells Excel to treat the entry as text. > --ron >Thanks ron > [quoted text clipped - 3 lines] >i have tried it on a colleagues computer and it does not auto format so >there must be a way to turn it off Can you format the cell as TEXT before you copy into it? --ron >Thanks ron > [quoted text clipped - 3 lines] >i have tried it on a colleagues computer and it does not auto format so >there must be a way to turn it off See http://support.microsoft.com/kb/812385/en-us --ron thanks ron thats helped me > >Thanks ron > > [quoted text clipped - 9 lines] > > --ron >thanks ron > [quoted text clipped - 13 lines] >> >> --ron Yes, I tried that registry hack on my machine and it corrected the "feature". --ron Yeah, thanks for finding that, Ron. I have experienced this before and could not figure out how to stop it so I just resigned myself to preceding the entry with an apostrophe. Biff >>thanks ron >> [quoted text clipped - 18 lines] > "feature". > --ron >Yeah, thanks for finding that, Ron. > >I have experienced this before and could not figure out how to stop it so I >just resigned myself to preceding the entry with an apostrophe. > >Biff You're welcome. I was motivated to research that when it occurred on my machine, and Max wrote that it did not occur on a colleague's machine. --ron |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.