Another Format?....

nolc · May 3rd, 2002, 11:13 AM

I have another format question...My Column B is already formatted as a date, so the date 083000 has the Value of 8/30/2000...BUT for some odd reason the Column looks like the one below. How do I get rid of the spaces prior to the date? Is there some kind of a Trim property for Columns?

___ --> represents 3 spaces

___083000
___120699
___120699
___120699
___111899
___112499
___111999

Thanks again,

[ This Message was edited by: nolc on 2002-05-03 10:14 ]

Brian from Maui · May 3rd, 2002, 11:49 AM

Nolc,

Try left alignment

Jack in the UK · May 3rd, 2002, 12:34 PM

to kill the space fine and replace

as my great friend Brian in the South P says .. left
.....

sen_edp · May 3rd, 2002, 04:24 PM

hello

use the trim function to remove spaces
or
clean function , which removes all nonprinting characters.

Rgrds

Andreas

May 3rd, 2002, 12:34 PM	#3
Jack in the UK Board Regular Join Date: Feb 2002 Posts: 3,065	to kill the space fine and replace as my great friend Brian in the South P says .. left ..... __________________ Free Excel based Web Toolbar available here. Jack in the UK J & R Excel Solutions "making Excel work for you"

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 3rd, 2002, 11:13 AM	#1
nolc New Member Join Date: May 2002 Location: Minneapolis, MN Posts: 9	I have another format question...My Column B is already formatted as a date, so the date 083000 has the Value of 8/30/2000...BUT for some odd reason the Column looks like the one below. How do I get rid of the spaces prior to the date? Is there some kind of a Trim property for Columns? ___ --> represents 3 spaces ___083000 ___120699 ___120699 ___120699 ___111899 ___112499 ___111999 Thanks again, [ This Message was edited by: nolc on 2002-05-03 10:14 ]

May 3rd, 2002, 11:49 AM	#2
Brian from Maui Board Regular Join Date: Feb 2002 Posts: 7,743	Nolc, Try left alignment

May 3rd, 2002, 04:24 PM	#4
sen_edp Board Regular Join Date: Mar 2002 Location: Hellas Posts: 553	hello use the trim function to remove spaces or clean function , which removes all nonprinting characters. Rgrds Andreas