Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Text is being converted to Date
I have my cell as "text"... here is an example of what is in the cell...
08-10-20-00-00-00 I need to do a Replace....Replace -00 with (leave it blank) Excel then converts my number to 8/10/2020 Where as I want it to display as 08-10-20 Please help and thanks in advance, Kacy |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Converting number or text to a Date Format | New Users to Excel | |||
Formulas dealing with text data | Excel Worksheet Functions | |||
Combine date with text | Excel Worksheet Functions | |||
EXTRACT TEXT FROM A DATE | Excel Worksheet Functions | |||
Date format within a text syntex? | Excel Worksheet Functions |