| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Cell with digits must be act like text
Hi all,
When I format a cell as text and I put there for instance 4 October 2008 Excel handled this as a date, but that's not what I want. I know when I type a quotation mark (') in front of 4 October 2008 then it will be seen as text but I don't want the customers to type a ' in fornt of all the dates. Thanks for the solution in advance ;) AMacEd |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to convert digits into text | Excel Worksheet Functions | |||
| text box that will leave only the last 4 digits entered | Excel Discussion (Misc queries) | |||
| going from digits to real text | Excel Discussion (Misc queries) | |||
| Digits to text | Excel Worksheet Functions | |||
| How can I convert digits to alpha text? | Excel Discussion (Misc queries) | |||
Threaded Mode
