LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default Set Cell.Value to the Formated value

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I correct ##### error in a cell formated as text? Sonia Excel Discussion (Misc queries) 4 September 4th 09 02:38 PM
Cell formated as text changes when copied jjk98 Excel Discussion (Misc queries) 5 May 22nd 07 01:15 PM
Paste a formated Cell with protection can it be done Ralf Excel Discussion (Misc queries) 1 February 16th 05 03:05 PM
VB6 - ADO - Excel XP, cell formated as text [email protected] Excel Programming 0 September 15th 03 03:38 PM
Read cell formated as Time Larry[_9_] Excel Programming 1 August 4th 03 07:08 PM


All times are GMT +1. The time now is 01:19 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"