Converting numbers stored as text to numbers

mando415

New Member
Joined
Jun 4, 2013
Messages
8
Hi - looking for help here. I have tried to use the small green triangle to "convert to number" but this returns a scientific value stored as "general" format (from 350298922105792620 to 3.50299E+17). I have also tried multiplying by 1 but this seems to be rounding the value (350298922105792000). :confused:

Edit: As reference data type = 2; logical value. Hope this helps

Stumped and confused over here. Does anyone have any recommendations?

Thank you
 
Last edited:

Some videos you may like

Excel Facts

Pivot Table Drill Down
Double-click any number in a pivot table to create a new report showing all detail rows that make up that number

Kentetsu

Well-known Member
Joined
Jan 22, 2004
Messages
520
When I see something like this "3.50299E+17" the first thing I do is make sure the column width is big enough to display the entire number.
 

Watch MrExcel Video

Forum statistics

Threads
1,118,855
Messages
5,574,677
Members
412,611
Latest member
MattDexx
Top