Posted to microsoft.public.excel.worksheet.functions

John

external usenet poster

Posts: 2,069

adding function

Hello,

How can I add "00" & "0" to the the following cells:
(A B ) Result C D
(1 72 ) 001 072

Regards,

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
Adding Time Function	Joe	Excel Worksheet Functions	4	September 27th 06 04:27 PM
PivotTable -adding more than one function	Connie	Excel Worksheet Functions	1	January 11th 06 06:58 AM
Adding a new comment with a function?	Cheese	Excel Discussion (Misc queries)	4	July 31st 05 11:46 AM
Help with adding certain cells using an IF function	Jrr6415sun	Excel Worksheet Functions	4	July 10th 05 11:10 PM
Adding text before a function	Eric	Excel Worksheet Functions	1	November 3rd 04 06:57 PM

All times are GMT +1. The time now is 02:45 PM.

About Us

"It's about Microsoft Excel"