How to convert number into text in excel

Closed
memo.1361 Posts 1 Registration date Saturday August 30, 2014 Status Member Last seen August 30, 2014 - Aug 30, 2014 at 03:59 AM
 Kulmalik - Aug 31, 2014 at 10:56 AM
Hello,
Thanks for the nice solution.
I have a problem and that's what should I do if the number is bigger than 999,999,999?


1 response

Use Text Function to convert value to text

Eg. =Text(B2,"0")
2