precision as displayed

  • Thread starter Thread starter Larry
  • Start date Start date
L

Larry

I am doing a text to columns on phone # that are in this format
"7890015"
in this case it displays in column as 1 as 789 and in the second
column as 15.
I have formated it as text and precision as displayed.
I am hoping to get this result 789 0015.
Any Hints?
 
You could either format the column after:

Select the column
format|cells|number tab
Custom category
0000

to show the leading 0's.

Or you could tell excel that you want the field (both fields???) treated as text
(not general) on step 3 of that data|text to columns wizard.

Precision as displayed has to do with decimal points.

12.234215123
formatted to 2 digits would show
12.23

And using precision as displayed, would chop those extra decimal places and
change the real value to 12.23.
 
Back
Top