Posted to microsoft.public.excel.worksheet.functions

Colin Hayes Colin Hayes is offline

external usenet poster

Posts: 465

Adding recognised Zeros

In article , Claus Busch
writes
Hi Colin,

Am Thu, 28 Nov 2013 19:13:23 +0000 schrieb Colin Hayes:

BTW I find I have a couple of 14 digit numbers in my column which give
#VALUE! Errors. Is there a way to ignore these numbers when running the
REPT formula?

try:
=REPT(0,MAX(LEN(A2),13)-LEN(A2))&A2

Regards
Claus B.

Hi Claus

OK that's entirely perfect.

Thanks Claus.

^_^

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 zeros to numbers in columns	Tim[_7_]	Excel Discussion (Misc queries)	1	October 18th 07 03:39 AM
Adding leading zeros	SITCFanTN	Excel Programming	3	July 10th 07 07:12 PM
adding zeros to a cell	DD	Excel Discussion (Misc queries)	3	April 29th 05 07:56 PM
Adding Leading Zeros to Text	Jenn	Excel Discussion (Misc queries)	4	January 12th 05 06:51 PM
Adding zeros	abxy[_43_]	Excel Programming	2	April 6th 04 05:53 PM

All times are GMT +1. The time now is 05:44 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us