View Single Post
  #1   Report Post  
myrddinbach
 
Posts: n/a
Default Specialized Cell Formatting

I have a column that contains a string of numbers, but I need to have
it formatted in a customized way using a few .'s. And I want to know if
there is any way I can set the formatting for this column so that it
will automatically change all the cells in this column without me
having ot manually do it.

Here's an example of what I need:
In each column a string of numbers like:

123456789012345

The string of numbers need to be formatted like so:

123456.78.901234.5

The column is already filled with numbers in the first example.
Can I somehow automate the formatting of this string of numbers so it
will automatically change them as in the second example?