View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pete_UK Pete_UK is offline
external usenet poster
 
Posts: 8,856
Default Stop excel rounding my 16/17 digit numbers

You need to treat them as text when you import to Excel, otherwise
values which are thought (by Excel) to be numbers will be truncated to
15 digit precision.

Hope this helps.

Pete

On Jan 9, 4:07*pm, E Halliday
wrote:
I receive a report which has transaction numbers either 16/17 digits long. *
Is there anyway I can retrieve the full number from excel?

Much appreciated.