Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel-How Do I prevent data conversion to date format
I am trying to input symbolic numerical data that includes forward slashes ie
"5/5" in a simple excel spread sheet. However when I do so, it converts the input into a date format ie: "5-may" or "5/5/07" Furthermore. Even if I erase the content from the "evil" cell in question, any future integer value ( ie: " 5 " ) entered in to that cell is converted to a date format. How do I prevent this from happening and/or disable this function in excel. Thanks for any and all help. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel-How Do I prevent data conversion to date format
On Sun, 30 Sep 2007 12:11:03 -0700, MadHatter8_10
wrote: I am trying to input symbolic numerical data that includes forward slashes ie "5/5" in a simple excel spread sheet. However when I do so, it converts the input into a date format ie: "5-may" or "5/5/07" Furthermore. Even if I erase the content from the "evil" cell in question, any future integer value ( ie: " 5 " ) entered in to that cell is converted to a date format. How do I prevent this from happening and/or disable this function in excel. Thanks for any and all help. The data must be entered into the cell as TEXT. This can be done either by 1. Format the cell as TEXT before entering the data (Format/Cells/Number/Text) 2. Precede the data with a single quote '2/2 --ron |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel-How Do I prevent data conversion to date format
Format the cell for "Text" *before* entering the data, or precede the data
with an apostrophe ('). The apostrophe will not show up in the cell but will show up in the formula bar. The apostrophe tells Excel to treat the data strictly as it was entered with no date or other conversions. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting www.cpearson.com (email on the web site) "MadHatter8_10" wrote in message ... I am trying to input symbolic numerical data that includes forward slashes ie "5/5" in a simple excel spread sheet. However when I do so, it converts the input into a date format ie: "5-may" or "5/5/07" Furthermore. Even if I erase the content from the "evil" cell in question, any future integer value ( ie: " 5 " ) entered in to that cell is converted to a date format. How do I prevent this from happening and/or disable this function in excel. Thanks for any and all help. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel-How Do I prevent data conversion to date format
Precede the 5/5 with a apostrophe or pre-format to Text
Gord Dibben MS Excel MVP On Sun, 30 Sep 2007 12:11:03 -0700, MadHatter8_10 wrote: I am trying to input symbolic numerical data that includes forward slashes ie "5/5" in a simple excel spread sheet. However when I do so, it converts the input into a date format ie: "5-may" or "5/5/07" Furthermore. Even if I erase the content from the "evil" cell in question, any future integer value ( ie: " 5 " ) entered in to that cell is converted to a date format. How do I prevent this from happening and/or disable this function in excel. Thanks for any and all help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
permanent conversion of 1904 date format to 1900 date format | Excel Worksheet Functions | |||
Conversion of date into different format | Excel Discussion (Misc queries) | |||
Date format conversion | Excel Discussion (Misc queries) | |||
How do I prevent Excel from auto-correcting the date format? | Excel Discussion (Misc queries) | |||
Date Format - Conversion | Excel Discussion (Misc queries) |