Saving Custom Formats

  • Thread starter Thread starter Bob Campbell
  • Start date Start date
B

Bob Campbell

Why is there no way to add my custom format to the list so
it is always available, rather than just saving it with a
specific file?

I have some tab seperated files i open, modify slightly
and save (still as tab seperated) a lot. It would be handy
to do this with excel because of other spreadsheet
features I would be able to make use of.

However, you can't store custom formats with a tab
seperated text file obviously.

In the file, there is a date-time format column with
entries like: "YYYY-MM-DD HH:MI:SS". The default when I
open it with excel is to make that into "YYYY-MM-DD
HH:MI". So when I save it I loose the seconds info.

Therefore I have to make sure I change the cell format:
But "YYYY-MM-DD HH:MI:SS" isn't even an alternative one so
i have to select "YYYY-MM-DD HH:MI", modify it to show the
SS and then save. Every time...

This is a real pain and seems very very back to front -
surely there is a way to change that custom format list
outside of a specific file. What if my organisation had
some custom formats we wanted all employees to be able to
use in their documents....

-

Dr Bob Campbell
Cognos Software Development
London
 
Write a macro that says "for each cell in the selection, set the format to
blah blah blah", attach it to a button on the toolbar and save it in
personal.xls or similar.
 
Back
Top