Can scientific notation be turned off?

F

Fan924

Can scientific notation be turned off in a workbook? I deal with rows
of hex numbers it continues to convert to scientific notation. Can I
just do away with it? Excel 97?
 
G

Gord Dibben

Depends upon what the rows of hex numbers look like and how you are entering
them

Usual workaround is to enter the numbers as text.

Preface the entry with an apostrophe or pre-format the cells to text.

Maybe a small sample of your data would help us to suggest something.


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

brain fart, need help 2
VBA - Hex Number Thinks Its Scientific 4
Avoid Scientific Notation 2
Scientific Notation - I wish MS Gave us a switch to turn it off 3
Can I get a number in such a format as it should be? 3
Turn Off Scientific Notation 3
Turn Off Scientific Notation 1
Converting a number (17 characters) to text (Scientific Notation) 4

Top