Formatting celle with LEFT

deuxo · Apr 1st, 2002, 11:45 AM

I am using the following function in a cell(A2)
=LEFT(A1,5), where I am trying to return the first 5 characters from A1, however I am unable to formatt cell A2. Anyone know how to format a cell that uses the LEFT function?

Fryer Tuck · Apr 1st, 2002, 11:56 AM

What type of format; the text itself, or the cell? (E.g. $1.23 or align right)

deuxo · Apr 1st, 2002, 12:50 PM

If I undertand your question correctly, I want to format the text, in my case I want to convert to a date.

Ricky Morris · Apr 1st, 2002, 01:26 PM

To format the result as date you should convert it to a value by using the value command. Your formula would be:

=Value(Left(a1,5))

Ricky

Al Chara · Apr 1st, 2002, 01:31 PM

Post some sample data, for clarification.

deuxo · Apr 1st, 2002, 03:05 PM

Thanks for responses, The VALUE function Ricky recommended did the trick.

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

Apr 1st, 2002, 11:45 AM	#1
deuxo New Member Join Date: Mar 2002 Posts: 13	I am using the following function in a cell(A2) =LEFT(A1,5), where I am trying to return the first 5 characters from A1, however I am unable to formatt cell A2. Anyone know how to format a cell that uses the LEFT function?

Apr 1st, 2002, 11:56 AM	#2
Fryer Tuck Board Regular Join Date: Mar 2002 Posts: 64	What type of format; the text itself, or the cell? (E.g. $1.23 or align right)

Apr 1st, 2002, 12:50 PM	#3
deuxo New Member Join Date: Mar 2002 Posts: 13	If I undertand your question correctly, I want to format the text, in my case I want to convert to a date.

Apr 1st, 2002, 01:26 PM	#4
Ricky Morris Board Regular Join Date: Mar 2002 Posts: 363	To format the result as date you should convert it to a value by using the value command. Your formula would be: =Value(Left(a1,5)) Ricky

Apr 1st, 2002, 01:31 PM	#5
Al Chara MrExcel MVP Join Date: Feb 2002 Location: Monterrey, Mexico Posts: 1,433	Post some sample data, for clarification.

Apr 1st, 2002, 03:05 PM	#6
deuxo New Member Join Date: Mar 2002 Posts: 13	Thanks for responses, The VALUE function Ricky recommended did the trick.