The UK Home Automation Archive

Archive Home
Group Home
Search Archive


Advanced Search

The UKHA-ARCHIVE IS CEASING OPERATIONS 31 DEC 2024


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

RE: Re: OT: Excel expertise required


  • To: <ukha_d@xxxxxxx>
  • Subject: RE: Re: OT: Excel expertise required
  • From: "Graham Howe" <graham@xxxxxxx>
  • Date: Wed, 18 Sep 2002 23:47:04 +0100
  • Mailing-list: list ukha_d@xxxxxxx; contact ukha_d-owner@xxxxxxx
  • Reply-to: ukha_d@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.

Home | Main Index | Thread Index

Comments to the Webmaster are always welcomed, please use this contact form . Note that as this site is a mailing list archive, the Webmaster has no control over the contents of the messages. Comments about message content should be directed to the relevant mailing list.