Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi All -
Simple one I think, but I can't connect the dots. Cell.value is a date with custom number formatting. File is saved off to tab delimited text. When reopened in Excel, Excel default formats the dates, as the format didn't stay with the file. Not what I want. How to I get around it? I'm thinking I have to change the date to a string and prepend an apostrophe. But what I'm thinking ain't working. Thanks in advance. ....best, Capt N. -- Scream and Shout and Jump for Joy! I was here before Kilroy! Sorry to spoil our little joke. I was here but my computer broke. ....Kilroy |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I correct ##### error in a cell formated as text? | Excel Discussion (Misc queries) | |||
Cell formated as text changes when copied | Excel Discussion (Misc queries) | |||
Paste a formated Cell with protection can it be done | Excel Discussion (Misc queries) | |||
VB6 - ADO - Excel XP, cell formated as text | Excel Programming | |||
Read cell formated as Time | Excel Programming |