| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Custom number formats | Excel Worksheet Functions | |||
| custom number formats | Excel Worksheet Functions | |||
| Custom Formats | Excel Discussion (Misc queries) | |||
| Custom Formats | Excel Discussion (Misc queries) | |||
| Custom Formats | Excel Discussion (Misc queries) | |||
Linear Mode
