Posted to microsoft.public.excel.programming

denileigh[_6_] denileigh[_6_] is offline

external usenet poster

Posts: 1

Formatting Question

I currently have a cell containing the following formula.

=RIGHT("000"&(T2),3)

This out puts a field like this: 00A

What I need is A00. I tried =LEFT but that didn't work.

Thanks for any help

--
denileig
-----------------------------------------------------------------------
denileigh's Profile: http://www.excelforum.com/member.php...fo&userid=3021
View this thread: http://www.excelforum.com/showthread.php?threadid=50955

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
Formatting question	Texas10	Excel Discussion (Misc queries)	3	October 13th 09 12:12 AM
Formatting Question	tecook02902	Excel Discussion (Misc queries)	2	March 21st 07 02:01 PM
Formatting Question	Zecarioca	Excel Discussion (Misc queries)	4	August 23rd 06 10:30 PM
Formatting Question	M.Siler	Excel Discussion (Misc queries)	3	July 18th 05 09:51 PM
Formatting Question	Kent	Excel Worksheet Functions	1	March 1st 05 06:26 PM

All times are GMT +1. The time now is 07:34 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us