ExcelBanter - custom formats

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - custom formats (https://www.excelbanter.com/excel-discussion-misc-queries/128739-custom-formats.html)

The big noise

custom formats

I am trying to store bank sort codes in Excel2003 and have tried 00-00-00 as
a format but this does not seem to work. It worked in Excel 97.
Anybody know how I can store numbers as nn-nn-nn?

Mike

custom formats

00\:00\:00\:00

Custom format of the above. Will that do?

"The big noise" wrote:

I am trying to store bank sort codes in Excel2003 and have tried 00-00-00 as
a format but this does not seem to work. It worked in Excel 97.
Anybody know how I can store numbers as nn-nn-nn?

Mike

custom formats

00-\0000-\0000-\0000

or even this. Adjust No of zeroes to suit

"The big noise" wrote:

I am trying to store bank sort codes in Excel2003 and have tried 00-00-00 as
a format but this does not seem to work. It worked in Excel 97.
Anybody know how I can store numbers as nn-nn-nn?

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