Posted to microsoft.public.excel.programming

Andibevan[_2_] Andibevan[_2_] is offline

external usenet poster

Posts: 128

Format of Variable

Hi All,

I have a cell with a named range Enter_RefNo

I want to format this variable in the format as follow

1 -- 0001
10 -- 0010
11 -- 0011

And so on

Any ideas?

Regards

Andi

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 variable #'s in a gen. format to a # that can be used w/ma	Steve	Excel Worksheet Functions	29	February 9th 10 01:19 AM
R1C1 format using a variable?	jim37055	Excel Discussion (Misc queries)	3	October 4th 05 05:47 PM
Format columns using a variable name	[email protected]	Excel Programming	2	April 13th 05 02:43 PM
format variable to 3 decimal	Wandering Mage	Excel Programming	1	July 19th 04 04:53 PM
Variable Reference in R1C1 format	Ndel40[_2_]	Excel Programming	1	February 20th 04 10:21 PM

All times are GMT +1. The time now is 06:50 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us