We are doing a data conversion from OpenVMS to Quicbooks by converting to an
Excel comma delimited file and importing to Quicbooks. Our problem: Column O,
P and R are phone numbers, fax numbers and cell phone numbers and are entered
in the cell as 10 digit numbers (Ex: 1234567890) and we need them converted
to 123.456.7890 (not just displayed, but actually in the field.) The columns
have headers in row one and the data values are from row 2 through 1141. I
have tried cut and paste special to a new column using custom formatting
###.###.#### which ends up as ##########.. We cannot figure out how to do
it and have very little experience with Excel formulas. PLEASE HELP!