| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
convert date as text to number
I want to subtract one date from another to obtain days between.
The format of the dates is dd/mm/yy This works fine if both dates are <<numbers. However, one date comes from a UserForm TextBox and is <<Text. I have used successfully the "PasteMultiply" by 1 trick to convert text that looks like a NUMBER to a true number, BUT it doesn't seem to work with text that looks like a DATE. Help please -- donwb |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Convert text date to general number | Excel Discussion (Misc queries) | |||
| convert text-format number to number in excel 2000%3f | Excel Discussion (Misc queries) | |||
| How do I convert a number formated as a date to text in Excel? | Excel Discussion (Misc queries) | |||
| Convert data type of cells to Text,Number,Date and Time | Excel Worksheet Functions | |||
| Convert data of cells to any type: Number, Date&Time, Text | Excel Discussion (Misc queries) | |||
Threaded Mode
