Desktop productivity for business analysts and programmers

ODS Excel

Reply
Contributor
Posts: 42

ODS Excel

I have a long number in my data and when do Ods Excel to send out the excel in an email the number is shown as significant digits in excel, is there a formatting i can do to show the whole number 

110001234567= 1.10001E+11

 

Super User
Posts: 24,003

Re: ODS Excel

What do you see in the formula bar? And what do you see in the cell?

 


@hk2013 wrote:

I have a long number in my data and when do Ods Excel to send out the excel in an email the number is shown as significant digits in excel, is there a formatting i can do to show the whole number 

110001234567= 1.10001E+11

 


 

Ask a Question
Discussion stats
  • 1 reply
  • 66 views
  • 0 likes
  • 2 in conversation