PDA

View Full Version : [SOLVED] Cell formating



blackie42
07-07-2014, 04:59 AM
Hi,

Just a quick question.

Trying to format some bank sort codes to 20-20-20 and using a format of ##-##-## but doing
this misses the leading 0 on codes like 02-02-02 so get 2-02-02.

Any ideas how to resolve

many thanks
Jon

mancubus
07-07-2014, 07:45 AM
Hi.

replace "#"s with "0"s.

blackie42
07-07-2014, 07:48 AM
thanks - so simple - so easy to overlook the obvious

regards

mancubus
07-07-2014, 07:50 AM
you're welcome.

:)