Retaining number format

**PooH** · 07-08-2010, 07:47 AM

Hello everyone,

First of all i want to thank everyone for the help they provide here.

I am facing difficulties in retaining the number format in excel sheet.
Example: I am pasting the number ‘123456789112345789’ to excel cell but displays as this ‘1.23457E+17’ then again I mail merge this number to word and it gives me the output as ‘1.23457E+17’. I want to have my end result in merged doc as ‘123456789112345789’ not the changed one.

Can anyone help in solving this for me?

Thank you

p.s: sometimes the number copied has letter in between them.

**JBeaucaire** · 07-08-2010, 07:56 AM

Place an apostrophe at the start of that string and it will be accepted as text. You can format the entire column as TEXT before you start entering values to help this as well.

**NBVC** · 07-08-2010, 07:58 AM

Excel cannot go past 15 digits of precision.. so your number is automatically converted.

You will need to paste it in to a cell that is preformatted as text or add an apostrophe in front.

**PooH** · 07-08-2010, 09:53 AM

I did both the steps: I preformatted the cell the text but it does not work. All i am doing is i am capturing this 16 digit number from web based application pasting it into excel which is then merged to a word document. I am doing all this thru a VBA macro code.

The main issue is i am not able to give the excat number as seen in web app in word document.