RE: Re: OT: Excel expertise required

["Graham Howe" <graham@xxxxxxx>]

> 
> Select your whole spreadsheet, right click it and click 
"format 
> cells" click the  "number" tab and scroll down the
left hand side 
> until you get to  "Custom" and click it, then in the
box 
> underneath  "Type:" enter ###,000 and click OK
> 
> This should convert everything to 001, 002, 030, 100, etc.
> 
Thanks for the suggestion Paul, unfortunately this only changes the
displayed format and as far as I know it only works with numbers, not
strings.

Graham

Yahoo! Groups Sponsor

ADVERTISEMENT

http://www.automatedhome.co.uk
Post message: ukha_d@xxxxxxx 
Subscribe:  ukha_d-subscribe@xxxxxxx 
Unsubscribe:  ukha_d-unsubscribe@xxxxxxx 
List owner:  ukha_d-owner@xxxxxxx
List of UKHA Groups here - http://groups.yahoo.com/group/UKHA_Grouplists/

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.