15+ Number Format
I said *PRE*-format, *PRE* meaning BEFORE entry, *not* after.
You said:
<<<"I am looking to format the column for *future* pastes."
FUTURE means *not already* existing data!
Try it that way - PRE-formatting.
--
HTH,
RD
---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"KB" wrote in message
...
That didn't work. Formatting the column cells to text reverting all the
numbers I already changed back to the 2.500013E+11 number.
"Ragdyer" wrote:
Pre-format the column to 'Text'.
--
HTH,
RD
--------------------------------------------------------------------------
-
Please keep all correspondence within the NewsGroup, so all may benefit
!
--------------------------------------------------------------------------
-
"KB" wrote in message
...
I understand anything over 15 #'s is too large and I know how to
change
it,
but I can only do it for the present numbers in a column. Any future
numbers
I paste into the column keeps reverting to something like
2.500013E+11. I
am
looking to format the column for future pastes. I know if you type
the '
will work but how can I format that in the column for future pastes?
|