Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Text, Number and Date formats excel 2003 driving experienced user
I have been using excel for several years and recently upgraded to 2003.
I have word documents containing tables of text in the form 45/23/03, when copied & pasted into excel, any that appear to be a date get converted to dates and appear as a date code. How can I stop this? I have columns of data eg 01020003, A203034, 2255003, which I enter as text, format as text and then may wish to sort/copy or use as the souce or table index in vlookup etc. whenever I copy or edit these excel 'automatically' converts the numbers to numeric etc, drops leading zeroes and so forth, so that they no longer sort properly and don't work in lookup etc. Is there any way to stop this automatinc reformatting of my data as it is seriously unproductive. Conversely, I have working formulae in cells and when I perform a minor edit they then display as text (this stopped hapenning after I switched off the 'allow editing in cell' option, although I was editing in the formula bar out of habit anyway). |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel cells should take number format and/or optional text eg Dec. | Excel Discussion (Misc queries) | |||
Converting number or text to a Date Format | New Users to Excel | |||
How do I extract a date as text not the 1900 reference number | Excel Discussion (Misc queries) | |||
How do I convert a number formated as a date to text in Excel? | Excel Discussion (Misc queries) | |||
Excel 2003 is changing my date formats | Excel Worksheet Functions |