We’d like to remind Forumites to please avoid political debate on the Forum.

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.

📨 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?

Comments

Gers Posts: 13,266 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