Pete Edwards
asked on
Formatting
How do I take this cell that was dumped out of a system and format to quantity.
we are missing information required in order to help you
ASKER
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Iammontoya,
Applied your formula and it just brought back a #Name.
Applied your formula and it just brought back a #Name.
you must have a valid value in that field... like if you had '239958
it would convert that to 239958
if you had pizza in that field.. it would not be able to convert that to a number
it would convert that to 239958
if you had pizza in that field.. it would not be able to convert that to a number
@Iammontoya if right: if you're actually looking at "######" like in your example, there is no number in that field, it's just a string of pound signs. Your import did not bring over numeric data that can be formatted.
ASKER
Thanks again.