Posted to microsoft.public.excel.worksheet.functions

Mike L.

external usenet poster

Posts: 1

I need to convert a number to text but I need it to be 5 position

I need to convert a number to text but it needs to be 5 positions. For
example of the number is 100, I need the text value to be 00100.

Any Ideas

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
Convert text number to number formate	[email protected]	Excel Discussion (Misc queries)	2	April 9th 07 10:48 AM
How to convert a number to text	conman	Excel Discussion (Misc queries)	2	June 8th 06 04:24 AM
find number position in excel text cell	Don	Excel Discussion (Misc queries)	5	April 7th 06 09:34 PM
convert text-format number to number in excel 2000%3f	Larry	Excel Discussion (Misc queries)	1	July 29th 05 08:18 PM
not able to convert text, or graphic number to regular number in e	knutsenk	Excel Worksheet Functions	1	April 2nd 05 08:41 AM

All times are GMT +1. The time now is 10:31 PM.

About Us

"It's about Microsoft Excel"