We'd like to remind Forumites to please avoid political debate on the Forum... Read More » This is to keep it a safe and useful space for MoneySaving discussions. Threads that are - or become - political in nature may be removed in line with the Forum’s rules. Thank you for your understanding.

We're aware that some users are experiencing technical issues which the team are working to resolve. See the Community Noticeboard for more info. Thank you for your patience.

📨 Have you signed up to the Forum's new Email Digest yet? Get a selection of trending threads sent straight to your inbox daily, weekly or monthly!

Excel query

Gers · 2018-12-15 15:11:46

I want to input numbers such as 17099131256910302 - it shows variously as: 9131256910302.00 when formatted as a number to 0 decimal places 1.70913E+15 when formatted as general or text How can I get this number to show correctly please?

Options

Comments

Gers Posts: 13,135 Forumite

16 December 2018 at 6:39PM

Tom99 wrote: »

I thought you might want to use the number in a calculation, maybe you are a time traveler? You question gave me a little mental exercise before breakfast - so thank you.

No, I just wanted to input into a cell.

And you're more than welcome, I was very happy that you encountered the same problem and knew how to overcome it.

0