On Sat, 3 Mar 2007, in microsoft.public.excel.charting,
margie said:

I need to format my charts to reflect 4 significant figures (not decimal
places) on both the x and the y axes. For example, I need to show 0.000,
5.000, but then continue on to 10.00, 15.00. A total of 4 digits (not
decimals must show). I am stumped.

Use this formula:

A1: [the number]
A2: [significant figures]
A3: =10^(A3-INT(LOG(A2)+0.5)-1)
A4: =INT(A2*A4+0.5)/A4

--
Del Cotter
NB Personal replies to this post will send email to ,
which goes to a spam folder-- please send your email to del3 instead.