Posted to microsoft.public.excel.newusers

exalan

external usenet poster

Posts: 28

Trim function

In cell A2, I use the trim function to trim cell A1 containing a date eg
1202/09, the result in A2 is 39856. However, this 39856 is text and not date
value. I therefore cannot convert it back to date after the trimming. Can
someone please help? Many thanks...
--
exalan

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
TRIM function	JockW	Excel Worksheet Functions	6	October 15th 08 10:41 PM
Len & Trim Function	Daren	Excel Worksheet Functions	6	October 14th 08 02:32 PM
TRIM FUNCTION...how to?	Shayra	Excel Worksheet Functions	3	March 10th 08 06:39 PM
Trim Function	Saxman[_2_]	Excel Discussion (Misc queries)	7	August 2nd 07 01:20 AM
Need help with TRIM function	Phil	Excel Worksheet Functions	9	October 21st 05 08:02 PM

All times are GMT +1. The time now is 05:55 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us