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) |